The Mac 12

home *** CD-ROM | disk | FTP | other *** search
/ The Mac 12 / the-mac-12.iso / Shareware City / Applications / macControl / macControl Help / macControl Help.rsrc
MacOS Resource Fork | 1995-05-09 | 376.1 KB | [help/CTRl]
open in:
MacOS 8.1 extracted |
Win98 extracted |
DOS extracted
browse contents |
view JSON data |
view as text

This file was processed as: MacOS Resource Fork (archive/rsrc).
Confidence	Program	Detection	Match Type	Support
`100%`	dexvert	MacOS Resource Fork `(archive/rsrc)`	magic	Supported
`10%`	dexvert	Jesper Olsen Module `(music/jesperOlsen)`	magic	Supported
`1%`	dexvert	BeOS Resource Data `(archive/beOSResourceData)`	ext	Unsupported
`1%`	dexvert	AppleSingle `(archive/appleSingle)`	fallback	Supported
`1%`	dexvert	TTComp Archive `(archive/ttcomp)`	fallback	Supported
`100%`	file	AppleDouble encoded Macintosh file	default
`99%`	file	data	default
`66%`	TrID	Mac AppleDouble encoded	default
`33%`	TrID	TTComp archive compressed (bin-2K)	default (weak)
`100%`	siegfried	fmt/503 AppleDouble Resource Fork (2)	default
`100%`	lsar	AppleSingle	default
id metadata
key	value
macFileType	`[help]`
macFileCreator	`[CTRl]`
hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 05 16 07 00 02 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000010| 00 00 00 00 00 00 00 00 | 00 02 00 00 00 09 00 00 |........|........|
|00000020| 00 32 00 00 00 20 00 00 | 00 02 00 00 00 52 00 05 |.2... ..|.....R..|
|00000030| e0 36 68 65 6c 70 43 54 | 52 6c 21 00 00 00 00 00 |.6helpCT|Rl!.....|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000050| 00 00 00 00 01 00 00 05 | c9 0d 00 05 c8 0d 00 00 |........|........|
|00000060| 17 29 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |.)......|........|
|00000070| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000080| 00 00 0f 6d 61 63 43 6f | 6e 74 72 6f 6c 20 48 65 |...macCo|ntrol He|
|00000090| 6c 70 02 00 00 00 68 65 | 6c 70 43 54 52 6c 21 00 |lp....he|lpCTRl!.|
|000000a0| 00 00 00 00 68 65 6c 70 | 43 54 52 6c 21 00 00 00 |....help|CTRl!...|
|000000b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000c0| 00 00 00 00 ab 56 7e 48 | 00 00 00 00 00 05 e0 36 |.....V~H|.......6|
|000000d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000100| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000110| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000120| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000150| 00 00 00 00 00 04 00 00 | 00 1b 00 00 00 36 03 00 |........|.....6..|
|00000160| 80 00 00 00 03 33 2e 35 | 2b 33 2e 35 2c 20 a9 20 |.....3.5|+3.5, . |
|00000170| 31 39 38 38 2d 31 39 39 | 34 20 42 72 65 69 74 73 |1988-199|4 Breits|
|00000180| 63 68 77 65 72 64 74 20 | 61 6e 64 20 50 61 72 74 |chwerdt |and Part|
|00000190| 6e 65 72 73 00 00 00 4e | 4d 54 68 69 73 20 64 6f |ners...N|MThis do|
|000001a0| 63 75 6d 65 6e 74 20 63 | 6f 6e 74 61 69 6e 73 20 |cument c|ontains |
|000001b0| 74 68 65 20 6d 61 63 43 | 6f 6e 74 72 6f 6c 2d 48 |the macC|ontrol-H|
|000001c0| 65 6c 70 2d 69 6e 66 6f | 72 6d 61 74 69 6f 6e 20 |elp-info|rmation |
|000001d0| 61 6e 64 20 63 61 6e 20 | 6e 6f 74 20 62 65 20 6f |and can |not be o|
|000001e0| 70 65 6e 65 64 2e 00 00 | 00 40 7f ff 40 01 47 f1 |pened...|.@..@.G.|
|000001f0| 49 c9 c9 4b 88 8a 88 8a | 84 8a 8f f2 90 12 95 12 |I..K....|........|
|00000200| da 93 55 11 4f e1 40 01 | 7f ff 7f ff 7f ff 7f ff |..U.O.@.|........|
|00000210| 7f ff ff ff ff ff ff fe | ff fe ff fe ff fe ff ff |........|........|
|00000220| ff ff 7f ff 7f ff 7f ff | 7f ff 00 00 01 00 0f ff |........|........|
|00000230| ff fe 10 00 00 01 10 00 | 00 01 10 00 00 01 10 07 |........|........|
|00000240| ff 81 10 08 00 41 10 10 | 78 21 10 10 cc 21 10 10 |.....A..|x!...!..|
|00000250| cc 25 50 10 18 2b b0 10 | 30 29 90 10 30 28 80 10 |.%P..+..|0)..0(..|
|00000260| 00 28 80 10 30 28 80 10 | 30 28 80 08 00 48 80 07 |.(..0(..|0(...H..|
|00000270| ff 88 80 00 00 08 80 ff | fe 08 81 00 01 08 91 50 |........|.......P|
|00000280| 01 08 b1 00 01 09 51 54 | 01 0b 11 00 01 05 11 55 |......QT|.......U|
|00000290| 01 01 11 00 01 01 11 55 | 41 01 11 00 01 01 10 ff |.......U|A.......|
|000002a0| fe 01 10 00 00 01 10 00 | 00 01 0f ff ff fe 0f ff |........|........|
|000002b0| ff fe 1f ff ff ff 1f ff | ff ff 1f ff ff ff 1f ff |........|........|
|000002c0| ff ff 1f ff ff ff 1f ff | ff ff 1f ff ff ff 1f ff |........|........|
|000002d0| ff ff 5f ff ff fb ff ff | ff f9 ff ff ff f8 ff ff |.._.....|........|
|000002e0| ff f8 ff ff ff f8 ff ff | ff f8 ff ff ff f8 ff ff |........|........|
|000002f0| ff f8 ff ff ff f8 ff ff | ff f8 ff ff ff f8 ff ff |........|........|
|00000300| ff f8 ff ff ff f9 5f ff | ff fb 1f ff ff ff 1f ff |......_.|........|
|00000310| ff ff 1f ff ff ff 1f ff | ff ff 1f ff ff ff 1f ff |........|........|
|00000320| ff ff 1f ff ff ff 1f ff | ff ff 0f ff ff fe 00 00 |........|........|
|00000330| 00 80 0f ff ff ff ff ff | ff ff 0f cc cc cc cc cc |........|........|
|00000340| cc cf 0f cc ce ee ee ee | cc cf 0f cc e7 7f ff 7d |........|.......}|
|00000350| ec cf ff cc e7 7f 7f 7d | ec ff fc cc e7 77 f7 7d |.......}|.....w.}|
|00000360| ec fc fc cc e7 77 f7 7d | ec f0 fc cc ee 77 f7 ee |.....w.}|.....w..|
|00000370| ec f0 fc cc ee ee ee ee | cc f0 fc ce cc cc cc ce |........|........|
|00000380| cc f0 fc ce ce cc cc ce | cc fc ff ce ec ec cc ce |........|........|
|00000390| cc ff 0f ce ce ce cc ce | cc cf 0f cc ee ee ee ec |........|........|
|000003a0| cc cf 0f cc cc cc cc cc | cc cf 0f ff ff ff ff ff |........|........|
|000003b0| ff ff 00 00 02 00 00 00 | ff ff ff ff ff ff ff ff |........|........|
|000003c0| ff ff ff ff ff f0 00 0f | 00 00 00 00 00 00 00 00 |........|........|
|000003d0| 00 00 00 00 00 0f 00 0f | 0c cc cc cc cc cc cc cc |........|........|
|000003e0| cc cc cc cc cc cf 00 0f | 0c cc cc cc cc cc cc cc |........|........|
|000003f0| cc cc cc cc cc cf 00 0f | 0c cc cc cc cf ff ff ff |........|........|
|00000400| ff ff fc cc cc cf 00 0f | 0c cc cc cc fc cc cc cc |........|........|
|00000410| cc cc df cc cc cf 00 0f | 0c cc cc cf cc 77 7f ff |........|.....w..|
|00000420| f7 7c cd fc cc cf 00 0f | 0c cc cc cf c7 77 ff 77 |.|......|.....w.w|
|00000430| ff 77 cd fc cc cf 00 0f | 0c cc cc cf c7 77 ff 77 |.w......|.....w.w|
|00000440| ff 77 cd fc cf cf 0f 0f | 0c cc cc cf c7 77 77 7f |.w......|.....ww.|
|00000450| f7 77 cd fc f0 ff f0 ff | 0c cc cc cf c7 77 77 ff |.w......|.....ww.|
|00000460| 77 77 cd fc f0 0f f0 0f | 0c cc cc cf c7 77 77 ff |ww......|.....ww.|
|00000470| 77 77 cd fc f0 00 f0 c0 | 0c cc cc cf c7 77 77 77 |ww......|.....www|
|00000480| 77 77 cd fc f0 00 f0 cc | cc cc cc cf c7 77 77 ff |ww......|.....ww.|
|00000490| 77 7c cd fc f0 00 f0 cc | cc cc cc cf cc 77 77 ff |w|......|.....ww.|
|000004a0| 7c cc dd fc f0 00 f0 cc | cc cc cc cc fc cc cc cc ||.......|........|
|000004b0| cc dd df cc f0 00 f0 cc | cc cc cc cc cf ff ff ff |........|........|
|000004c0| ff ff fc cc f0 00 f0 cc | cc cc cc cc cc cc cc cc |........|........|
|000004d0| cc cc cc cc f0 00 f0 cc | cc cc ee ee ee ee ee ee |........|........|
|000004e0| ee ec cc cc f0 00 f0 cc | cc ce 00 00 00 00 00 00 |........|........|
|000004f0| 00 0e cc cc f0 00 f0 cf | 0c ce 0e ce cc cc cc cc |........|........|
|00000500| cc de cc cc f0 00 f0 ff | 0c ce 0c cc cc cc cc cc |........|........|
|00000510| cc de cc cc f0 0f 0f 0f | 0c ce 0e ce ce cc cc cc |........|........|
|00000520| cc de cc cc f0 ff 00 0f | 0c ce 0c cc cc cc cc cc |........|........|
|00000530| cc de cc cc cf cf 00 0f | 0c ce 0e ce ce ce cc cc |........|........|
|00000540| cc de cc cc cc cf 00 0f | 0c ce 0c cc cc cc cc cc |........|........|
|00000550| cc de cc cc cc cf 00 0f | 0c ce 0e ce ce ce ce cc |........|........|
|00000560| cc de cc cc cc cf 00 0f | 0c ce dd dd dd dd dd dd |........|........|
|00000570| dd de cc cc cc cf 00 0f | 0c cc ee ee ee ee ee ee |........|........|
|00000580| ee ec cc cc cc cf 00 0f | 0c cc cc cc cc cc cc cc |........|........|
|00000590| cc cc cc cc cc cf 00 0f | 0c cc cc cc cc cc cc cc |........|........|
|000005a0| cc cc cc cc cc cf 00 00 | ff ff ff ff ff ff ff ff |........|........|
|000005b0| ff ff ff ff ff f0 00 00 | 01 00 00 ff ff ff ff ff |........|........|
|000005c0| ff ff ff ff ff ff ff ff | ff ff 00 ff f6 f6 f6 f6 |........|........|
|000005d0| f6 f6 f6 f6 f6 f6 f6 f6 | f6 ff 00 ff f6 f6 f6 fc |........|........|
|000005e0| fc fc fc fc fc fc f6 f6 | f6 ff 00 ff f6 f6 fc c0 |........|........|
|000005f0| c0 ff ff ff c0 f9 fc f6 | f6 ff ff ff f6 f6 fc c0 |........|........|
|00000600| c0 ff c0 ff c0 f9 fc f6 | ff ff ff f6 f6 f6 fc c0 |........|........|
|00000610| c0 c0 ff c0 c0 f9 fc f6 | ff f6 ff f6 f6 f6 fc c0 |........|........|
|00000620| c0 c0 ff c0 c0 f9 fc f6 | ff 00 ff f6 f6 f6 fc fc |........|........|
|00000630| c0 c0 ff c0 fc fc fc f6 | ff 00 ff f6 f6 f6 fc fc |........|........|
|00000640| fc fc fc fc fc fc f6 f6 | ff 00 ff f6 f6 fc f7 f7 |........|........|
|00000650| f7 f7 f7 f7 f7 fc f6 f6 | ff 00 ff f6 f6 fc f7 fc |........|........|
|00000660| f7 f7 f7 f7 f7 fc f6 f6 | ff f6 ff ff f6 fc fc f7 |........|........|
|00000670| fc f7 f7 f7 f7 fc f6 f6 | ff ff 00 ff f6 fc f7 fc |........|........|
|00000680| f7 fc f7 f7 f7 fc f6 f6 | f6 ff 00 ff f6 f6 fc fc |........|........|
|00000690| fc fc fc fc fc f6 f6 f6 | f6 ff 00 ff f6 f6 f6 f6 |........|........|
|000006a0| f6 f6 f6 f6 f6 f6 f6 f6 | f6 ff 00 ff ff ff ff ff |........|........|
|000006b0| ff ff ff ff ff ff ff ff | ff ff 00 00 04 00 00 00 |........|........|
|000006c0| 00 00 ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000006d0| ff ff ff ff ff ff ff ff | ff ff ff ff ff 00 00 00 |........|........|
|000006e0| 00 ff 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 ff 00 00 |........|........|
|00000700| 00 ff 00 f6 f6 f6 f6 f6 | f6 f6 f6 f6 f6 f6 f6 f6 |........|........|
|00000710| f6 f6 f6 f6 f6 f6 f6 f6 | f6 f6 f6 f6 f6 ff 00 00 |........|........|
|00000720| 00 ff 00 f6 f6 f6 f6 f6 | f6 f6 f6 f6 f6 f6 f6 f6 |........|........|
|00000730| f6 f6 f6 f6 f6 f6 f6 f6 | f6 f6 f6 f6 f6 ff 00 00 |........|........|
|00000740| 00 ff 00 f6 f6 f6 f6 f6 | f6 f6 2b ff ff ff ff ff |........|..+.....|
|00000750| ff ff ff ff ff ff ff f6 | f6 f6 f6 f6 f6 ff 00 00 |........|........|
|00000760| 00 ff 00 f6 f6 f6 f6 f6 | f6 2b ff 2b 2b 2b 2b 2b |........|.+.+++++|
|00000770| 2b 2b 2b 2b 2b 2b f9 ff | f6 f6 f6 f6 f6 ff 00 00 |++++++..|........|
|00000780| 00 ff 00 f6 f6 f6 f6 f6 | f6 ff 2b 2b c0 c0 c0 ff |........|..++....|
|00000790| ff ff ff c0 c0 2b 2b f9 | ff f6 f6 f6 f6 ff 00 00 |.....++.|........|
|000007a0| 00 ff 00 f6 f6 f6 f6 f6 | f6 ff 2b c0 c0 c0 ff ff |........|..+.....|
|000007b0| c0 c0 ff ff c0 c0 2b f9 | ff f6 f6 f6 f6 ff 00 00 |......+.|........|
|000007c0| 00 ff 00 f6 f6 f6 f6 f6 | f6 ff 2b c0 c0 c0 ff ff |........|..+.....|
|000007d0| c0 c0 ff ff c0 c0 2b f9 | ff f6 f6 ff f6 ff 00 ff |......+.|........|
|000007e0| 00 ff 00 f6 f6 f6 f6 f6 | f6 ff 2b c0 c0 c0 c0 c0 |........|..+.....|
|000007f0| c0 ff ff c0 c0 c0 2b f9 | ff f6 ff 00 ff ff ff 00 |......+.|........|
|00000800| ff ff 00 f6 f6 f6 f6 f6 | f6 ff 2b c0 c0 c0 c0 c0 |........|..+.....|
|00000810| ff ff c0 c0 c0 c0 2b f9 | ff f6 ff 00 00 ff ff 00 |......+.|........|
|00000820| 00 ff 00 f6 f6 f6 f6 f6 | f6 ff 2b c0 c0 c0 c0 c0 |........|..+.....|
|00000830| ff ff c0 c0 c0 c0 2b f9 | ff f6 ff 00 00 00 ff 00 |......+.|........|
|00000840| f6 00 00 f6 f6 f6 f6 f6 | f6 ff 2b c0 c0 c0 c0 c0 |........|..+.....|
|00000850| c0 c0 c0 c0 c0 c0 2b f9 | ff f6 ff 00 00 00 ff 00 |......+.|........|
|00000860| f6 f6 f6 f6 f6 f6 f6 f6 | f6 ff 2b c0 c0 c0 c0 c0 |........|..+.....|
|00000870| ff ff c0 c0 c0 2b 2b f9 | ff f6 ff 00 00 00 ff 00 |.....++.|........|
|00000880| f6 f6 f6 f6 f6 f6 f6 f6 | f6 ff 2b 2b c0 c0 c0 c0 |........|..++....|
|00000890| ff ff c0 2b 2b 2b f9 f9 | ff f6 ff 00 00 00 ff 00 |...+++..|........|
|000008a0| f6 f6 f6 f6 f6 f6 f6 f6 | f6 f6 ff 2b 2b 2b 2b 2b |........|...+++++|
|000008b0| 2b 2b 2b 2b f9 f9 f9 ff | f6 f6 ff 00 00 00 ff 00 |++++....|........|
|000008c0| f6 f6 f6 f6 f6 f6 f6 f6 | f6 f6 f6 ff ff ff ff ff |........|........|
|000008d0| ff ff ff ff ff ff ff f6 | f6 f6 ff 00 00 00 ff 00 |........|........|
|000008e0| f6 f6 f6 f6 f6 f6 f6 f6 | f6 f6 f6 f6 f6 f6 f6 f6 |........|........|
|000008f0| f6 f6 f6 f6 f6 f6 f6 f6 | f6 f6 ff 00 00 00 ff 00 |........|........|
|00000900| f6 f6 f6 f6 f6 f6 fc fc | fc fc fc fc fc fc fc fc |........|........|
|00000910| fc fc fc fc fc 2b f6 2b | f6 2b ff 00 00 00 ff 00 |.....+.+|.+......|
|00000920| f6 f6 f6 f6 f6 fc f5 f5 | f5 f5 f5 f5 f5 f5 f5 f5 |........|........|
|00000930| f5 f5 f5 f5 f5 fc f6 f6 | f6 f6 ff 00 00 00 ff 00 |........|........|
|00000940| f6 ff 00 f6 f6 fc f5 fc | f7 fc f7 f7 f7 f7 f7 f7 |........|........|
|00000950| f7 f7 f7 f7 fa fc f6 f6 | f6 f6 ff 00 00 00 ff 00 |........|........|
|00000960| ff ff 00 f6 f6 fc f5 f7 | f7 f7 f7 f7 f7 f7 f7 f7 |........|........|
|00000970| f7 f7 f7 f7 fa fc f6 f6 | f6 f6 ff 00 00 ff 00 ff |........|........|
|00000980| 00 ff 00 f6 f6 fc f5 fc | f7 fc f7 fc f7 f7 f7 f7 |........|........|
|00000990| f7 f7 f7 f7 fa fc f6 f6 | f6 f6 ff 00 ff ff 00 00 |........|........|
|000009a0| 00 ff 00 f6 f6 fc f5 f7 | f7 f7 f7 f7 f7 f7 f7 f7 |........|........|
|000009b0| f7 f7 f7 f7 fa fc f6 f6 | f6 f6 f6 ff f6 ff 00 00 |........|........|
|000009c0| 00 ff 00 f6 f6 fc f5 fc | f7 fc f7 fc f7 fc f7 f7 |........|........|
|000009d0| f7 f7 f7 f7 fa fc f6 f6 | f6 f6 f6 f6 f6 ff 00 00 |........|........|
|000009e0| 00 ff 00 f6 f6 fc f5 f7 | f7 f7 f7 f7 f7 f7 f7 f7 |........|........|
|000009f0| f7 f7 f7 f7 fa fc f6 f6 | f6 f6 f6 f6 f6 ff 00 00 |........|........|
|00000a00| 00 ff 00 f6 f6 fc f5 fc | f7 fc f7 fc f7 fc f7 fc |........|........|
|00000a10| f7 f7 f7 f7 fa fc f6 f6 | f6 f6 f6 f6 f6 ff 00 00 |........|........|
|00000a20| 00 ff 00 f6 f6 fc fa fa | fa fa fa fa fa fa fa fa |........|........|
|00000a30| fa fa fa fa fa fc f6 f6 | f6 f6 f6 f6 f6 ff 00 00 |........|........|
|00000a40| 00 ff 00 f6 f6 f6 fc fc | fc fc fc fc fc fc fc fc |........|........|
|00000a50| fc fc fc fc fc f6 f6 f6 | f6 f6 f6 f6 f6 ff 00 00 |........|........|
|00000a60| 00 ff 00 f6 f6 f6 f6 f6 | f6 f6 f6 f6 f6 f6 f6 f6 |........|........|
|00000a70| f6 f6 f6 f6 f6 f6 f6 f6 | f6 f6 f6 f6 f6 ff 00 00 |........|........|
|00000a80| 00 ff 00 f6 f6 f6 f6 f6 | f6 f6 f6 f6 f6 f6 f6 f6 |........|........|
|00000a90| f6 f6 f6 f6 f6 f6 f6 f6 | f6 f6 f6 f6 f6 ff 00 00 |........|........|
|00000aa0| 00 00 ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000ab0| ff ff ff ff ff ff ff ff | ff ff ff ff ff 00 00 00 |........|........|
|00000ac0| 00 07 68 65 6c 70 00 00 | 00 00 00 00 1c 43 54 52 |..help..|.....CTR|
|00000ad0| 6c 00 00 00 01 49 43 4e | 23 00 00 00 00 00 b4 46 |l....ICN|#......F|
|00000ae0| 52 45 46 00 00 00 00 00 | 86 00 00 00 da 00 08 1c |REF.....|........|
|00000af0| 46 6f 72 20 64 65 66 69 | 6e 69 6e 67 20 61 20 64 |For defi|ning a d|
|00000b00| 61 74 61 62 61 73 65 20 | 63 65 6c 6c 16 46 6f 72 |atabase |cell.For|
|00000b10| 20 64 65 66 69 6e 69 6e | 67 20 61 20 66 6f 72 6d | definin|g a form|
|00000b20| 75 6c 61 27 46 6f 72 20 | 64 65 66 69 6e 69 6e 67 |ula'For |defining|
|00000b30| 20 61 6e 20 61 74 74 72 | 69 62 75 74 65 2d 20 6f | an attr|ibute- o|
|00000b40| 72 20 6d 65 6e 75 20 63 | 65 6c 6c 18 46 6f 72 20 |r menu c|ell.For |
|00000b50| 64 65 66 69 6e 69 6e 67 | 20 61 20 74 69 6d 65 20 |defining| a time |
|00000b60| 63 65 6c 6c 2c 53 74 6f | 70 73 20 74 68 65 20 65 |cell,Sto|ps the e|
|00000b70| 6e 74 72 79 2c 20 77 69 | 74 68 6f 75 74 20 73 74 |ntry, wi|thout st|
|00000b80| 6f 72 69 6e 67 20 74 68 | 65 20 63 68 61 6e 67 65 |oring th|e change|
|00000b90| 73 19 45 6e 64 73 20 61 | 6e 64 20 73 74 6f 72 65 |s.Ends a|nd store|
|00000ba0| 73 20 74 68 65 20 65 6e | 74 72 79 1a 4f 70 65 6e |s the en|try.Open|
|00000bb0| 73 20 74 68 65 20 61 74 | 74 72 69 62 75 74 65 20 |s the at|tribute |
|00000bc0| 77 69 6e 64 6f 77 00 00 | 00 00 b3 53 75 6d 6d 61 |window..|...Summa|
|00000bd0| 74 69 6f 6e 20 46 75 6e | 63 74 69 6f 6e 0d 0d 53 |tion Fun|ction..S|
|00000be0| 55 4d 20 28 20 46 5b 31 | 2e 2e 31 30 2c 34 5d 20 |UM ( F[1|..10,4] |
|00000bf0| 29 0d 0d 6f 72 0d 53 61 | 6c 65 73 3a 31 2f 39 30 |)..or.Sa|les:1/90|
|00000c00| 20 3d 20 53 55 4d 28 20 | a5 50 72 6f 64 75 63 74 | = SUM( |.Product|
|00000c10| 0d 3a 28 61 6c 6c 29 3a | 53 61 6c 65 73 3a 31 2f |.:(all):|Sales:1/|
|00000c20| 39 30 20 29 0d 0d 6f 72 | 0d 53 61 6c 65 73 3a a5 |90 )..or|.Sales:.|
|00000c30| 50 72 6f 64 75 63 74 20 | 47 72 6f 75 70 73 3a 31 |Product |Groups:1|
|00000c40| 2f 39 30 20 3d 0d 53 55 | 4d 28 20 a5 50 72 6f 64 |/90 =.SU|M( .Prod|
|00000c50| 75 63 74 3a 28 41 73 73 | 69 67 6e 6d 65 6e 74 0d |uct:(Ass|ignment.|
|00000c60| 3a a5 50 72 6f 64 75 63 | 74 20 47 72 6f 75 70 73 |:.Produc|t Groups|
|00000c70| 29 3a 53 61 6c 65 73 3a | 31 2f 39 30 20 29 00 00 |):Sales:|1/90 )..|
|00000c80| 00 69 47 69 76 65 73 20 | 74 68 65 20 63 75 72 72 |.iGives |the curr|
|00000c90| 65 6e 74 20 64 61 74 65 | 20 0d 6f 72 20 74 68 65 |ent date| .or the|
|00000ca0| 20 63 75 72 72 65 6e 74 | 20 74 69 6d 65 0d 0d 44 | current| time..D|
|00000cb0| 41 54 45 54 49 4d 45 20 | 28 30 29 20 67 69 76 65 |ATETIME |(0) give|
|00000cc0| 73 20 74 68 65 20 64 61 | 74 65 0d 0d 6f 72 0d 44 |s the da|te..or.D|
|00000cd0| 41 54 45 54 49 4d 45 20 | 28 31 29 20 67 69 76 65 |ATETIME |(1) give|
|00000ce0| 73 20 74 68 65 20 74 69 | 6d 65 0d 00 00 00 2d 43 |s the ti|me....-C|
|00000cf0| 68 61 6e 67 65 73 20 61 | 6e 79 20 64 61 74 61 20 |hanges a|ny data |
|00000d00| 74 79 70 65 20 74 6f 20 | 74 65 78 74 0d 0d 54 45 |type to |text..TE|
|00000d10| 58 54 20 28 20 56 61 6c | 75 65 20 29 00 00 00 78 |XT ( Val|ue )...x|
|00000d20| 43 68 61 6e 67 65 73 20 | 61 6e 79 20 74 69 6d 65 |Changes |any time|
|00000d30| 20 72 65 66 65 72 65 6e | 63 65 20 0d 69 6e 74 6f | referen|ce .into|
|00000d40| 20 61 20 6d 6f 6e 74 68 | 6c 79 20 74 69 6d 65 20 | a month|ly time |
|00000d50| 72 65 66 65 72 65 6e 63 | 65 20 0d 0d 4d 4f 4e 54 |referenc|e ..MONT|
|00000d60| 48 20 28 20 44 61 74 65 | 20 29 0d 0d 28 66 6f 72 |H ( Date| )..(for|
|00000d70| 20 65 78 61 6d 70 6c 65 | 2c 20 31 39 39 31 20 6f | example|, 1991 o|
|00000d80| 72 20 31 2f 31 33 2f 39 | 31 0d 62 65 63 6f 6d 65 |r 1/13/9|1.become|
|00000d90| 73 20 31 2f 39 31 20 29 | 00 00 00 ad 4d 61 6b 65 |s 1/91 )|....Make|
|00000da0| 73 20 70 6f 73 73 69 62 | 6c 65 20 0d 63 6f 6e 64 |s possib|le .cond|
|00000db0| 69 74 69 6f 6e 61 6c 20 | 63 61 6c 63 75 6c 61 74 |itional |calculat|
|00000dc0| 69 6f 6e 73 0d 0d 49 46 | 20 28 20 46 5b 63 31 2c |ions..IF| ( F[c1,|
|00000dd0| 72 31 5d 20 3e 20 46 5b | 63 32 2c 72 32 5d 20 29 |r1] > F[|c2,r2] )|
|00000de0| 20 54 48 45 4e 20 0d 28 | 20 46 5b 63 33 2c 72 33 | THEN .(| F[c3,r3|
|00000df0| 5d 20 29 20 45 4c 53 45 | 20 28 20 46 5b 63 34 2c |] ) ELSE| ( F[c4,|
|00000e00| 72 34 5d 20 29 0d 0d 6f | 72 0d 49 46 20 28 20 a5 |r4] )..o|r.IF ( .|
|00000e10| 50 72 6f 64 75 63 74 3a | 53 61 6c 65 73 3a 31 2f |Product:|Sales:1/|
|00000e20| 39 30 20 3c 20 31 30 30 | 30 20 29 0d 54 48 45 4e |90 < 100|0 ).THEN|
|00000e30| 20 28 20 54 61 78 20 31 | 20 29 20 45 4c 53 45 20 | ( Tax 1| ) ELSE |
|00000e40| 28 20 54 61 78 20 32 20 | 29 00 00 00 5e 45 4d 50 |( Tax 2 |)...^EMP|
|00000e50| 54 59 20 28 30 29 20 72 | 65 70 72 65 73 65 6e 74 |TY (0) r|epresent|
|00000e60| 73 0d 61 6e 20 65 6d 70 | 74 79 20 66 69 65 6c 64 |s.an emp|ty field|
|00000e70| 0d 0d 49 46 20 28 20 46 | 5b 63 31 2c 72 31 5d 20 |..IF ( F|[c1,r1] |
|00000e80| 3d 20 45 4d 50 54 59 20 | 28 30 29 20 29 20 0d 54 |= EMPTY |(0) ) .T|
|00000e90| 48 45 4e 20 28 20 30 20 | 29 20 45 4c 53 45 20 28 |HEN ( 0 |) ELSE (|
|00000ea0| 20 46 5b 63 32 2c 72 32 | 5d 20 29 00 00 00 51 67 | F[c2,r2|] )...Qg|
|00000eb0| 69 76 65 73 20 74 68 65 | 20 72 65 66 65 72 65 6e |ives the| referen|
|00000ec0| 63 65 20 20 20 20 20 20 | 0d 64 65 6e 6f 74 61 74 |ce      |.denotat|
|00000ed0| 69 6f 6e 20 6f 66 20 61 | 20 63 65 6c 6c 20 20 20 |ion of a| cell   |
|00000ee0| 20 20 20 20 20 0d 0d 43 | 45 4c 4c 52 45 46 45 52 |     ..C|ELLREFER|
|00000ef0| 45 4e 43 45 20 28 46 5b | 72 2c 63 5d 29 20 20 20 |ENCE (F[|r,c])   |
|00000f00| 00 00 00 49 47 69 76 65 | 73 20 74 68 65 20 6e 61 |...IGive|s the na|
|00000f10| 6d 65 20 6f 66 20 74 68 | 65 20 75 73 65 72 0d 77 |me of th|e user.w|
|00000f20| 68 6f 20 69 73 20 6c 6f | 67 67 65 64 20 69 6e 74 |ho is lo|gged int|
|00000f30| 6f 20 74 68 65 20 0d 64 | 61 74 61 62 61 73 65 0d |o the .d|atabase.|
|00000f40| 0d 55 53 45 52 4e 41 4d | 45 20 28 30 29 00 00 00 |.USERNAM|E (0)...|
|00000f50| ff 43 6f 6d 62 69 6e 65 | 73 20 6d 75 6c 74 69 70 |.Combine|s multip|
|00000f60| 6c 65 20 4d 61 63 72 6f | 20 66 6f 72 6d 75 6c 61 |le Macro| formula|
|00000f70| 73 20 0d 69 6e 74 6f 20 | 61 20 73 69 6e 67 6c 65 |s .into |a single|
|00000f80| 20 66 6f 72 6d 75 6c 61 | 0d 0d 4d 61 63 72 6f 66 | formula|..Macrof|
|00000f90| 6f 72 6d 75 6c 61 3a 4e | 4f 69 3a 28 57 6f 72 6b |ormula:N|Oi:(Work|
|00000fa0| 73 68 65 65 74 29 20 3d | 0d 4d 41 43 52 4f 20 28 |sheet) =|.MACRO (|
|00000fb0| 46 5b 63 31 2e 2e 63 32 | 2c 72 31 2e 2e 72 32 5d |F[c1..c2|,r1..r2]|
|00000fc0| 3b 20 6e 3b 20 6d 29 0d | 0d 6e 20 3d 20 30 20 20 |; n; m).|.n = 0  |
|00000fd0| 77 69 74 68 20 44 69 73 | 70 6c 61 79 3b 20 20 0d |with Dis|play;  .|
|00000fe0| 6e 20 3d 20 31 20 20 77 | 69 74 68 6f 75 74 20 44 |n = 1  w|ithout D|
|00000ff0| 69 73 70 6c 61 79 3b 0d | 6d 20 3d 20 30 20 6d 61 |isplay;.|m = 0 ma|
|00001000| 6e 75 61 6c 20 73 74 61 | 72 74 3b 0d 6d 20 3d 20 |nual sta|rt;.m = |
|00001010| 32 20 61 75 74 6f 6d 61 | 74 69 63 20 73 74 61 72 |2 automa|tic star|
|00001020| 74 3b 0d 46 5b 63 31 2e | 2e 63 32 2c 72 31 2e 2e |t;.F[c1.|.c2,r1..|
|00001030| 72 32 5d 20 63 6f 6e 74 | 61 69 6e 73 20 74 68 65 |r2] cont|ains the|
|00001040| 20 0d 4d 61 63 72 6f 20 | 66 6f 72 6d 75 6c 61 73 | .Macro |formulas|
|00001050| 00 00 00 c7 4d 61 63 72 | 6f 66 75 6e 63 74 69 6f |....Macr|ofunctio|
|00001060| 6e 20 74 68 61 74 20 65 | 6e 61 62 6c 65 73 20 74 |n that e|nables t|
|00001070| 68 65 20 75 73 65 72 0d | 74 6f 20 61 75 74 6f 6d |he user.|to autom|
|00001080| 61 74 69 63 61 6c 6c 79 | 20 70 72 69 6e 74 20 61 |atically| print a|
|00001090| 20 67 69 76 65 6e 20 73 | 65 74 20 6f 66 0d 70 61 | given s|et of.pa|
|000010a0| 67 65 73 0d 0d 4d 61 63 | 72 6f 66 6f 72 6d 75 6c |ges..Mac|roformul|
|000010b0| 61 20 3a 20 4e 4f 69 20 | 3a 20 28 57 6f 72 6b 73 |a : NOi |: (Works|
|000010c0| 68 65 65 74 29 20 3d 20 | 0d 41 55 54 4f 50 52 49 |heet) = |.AUTOPRI|
|000010d0| 4e 54 20 28 20 46 5b 63 | 31 2e 2e 63 32 2c 72 31 |NT ( F[c|1..c2,r1|
|000010e0| 2e 2e 72 32 5d 20 29 0d | 0d 28 46 5b 63 31 2e 2e |..r2] ).|.(F[c1..|
|000010f0| 63 32 2c 72 31 2e 2e 72 | 32 5d 20 64 65 66 69 6e |c2,r1..r|2] defin|
|00001100| 65 73 20 74 68 65 20 70 | 61 67 65 73 0d 74 6f 20 |es the p|ages.to |
|00001110| 62 65 20 70 72 69 6e 74 | 65 64 29 00 00 00 9f 4d |be print|ed)....M|
|00001120| 61 63 72 6f 66 75 6e 63 | 74 69 6f 6e 20 74 68 61 |acrofunc|tion tha|
|00001130| 74 20 6f 70 65 6e 73 20 | 61 20 64 69 61 6c 6f 67 |t opens |a dialog|
|00001140| 2e 20 54 68 65 20 20 20 | 0d 75 73 65 72 20 6d 61 |. The   |.user ma|
|00001150| 79 20 71 75 69 74 20 74 | 68 65 20 6d 61 63 72 6f |y quit t|he macro|
|00001160| 20 66 72 6f 6d 20 77 68 | 69 63 68 20 20 20 20 20 | from wh|ich     |
|00001170| 0d 74 68 69 73 20 6d 61 | 63 72 6f 66 75 6e 63 74 |.this ma|crofunct|
|00001180| 69 6f 6e 20 68 61 73 20 | 62 65 65 6e 20 63 61 6c |ion has |been cal|
|00001190| 6c 65 64 20 75 70 2e 20 | 20 20 20 0d 0d 43 4f 4e |led up. |   ..CON|
|000011a0| 46 49 52 4d 20 28 22 44 | 6f 20 79 6f 75 20 77 61 |FIRM ("D|o you wa|
|000011b0| 6e 74 20 74 6f 20 71 75 | 69 74 20 3f 22 29 00 00 |nt to qu|it ?")..|
|000011c0| 00 6d 43 68 61 6e 67 65 | 73 20 61 6e 79 20 74 69 |.mChange|s any ti|
|000011d0| 6d 65 20 72 65 66 65 72 | 65 6e 63 65 20 0d 69 6e |me refer|ence .in|
|000011e0| 74 6f 20 61 20 79 65 61 | 72 6c 79 20 74 69 6d 65 |to a yea|rly time|
|000011f0| 20 72 65 66 65 72 65 6e | 63 65 0d 0d 59 45 41 52 | referen|ce..YEAR|
|00001200| 20 28 20 44 61 74 65 20 | 29 0d 0d 28 66 6f 72 20 | ( Date |)..(for |
|00001210| 65 78 61 6d 70 6c 65 2c | 20 31 2f 31 33 2f 39 31 |example,| 1/13/91|
|00001220| 20 0d 62 65 63 6f 6d 65 | 73 20 31 39 39 31 29 00 | .become|s 1991).|
|00001230| 00 00 19 6c 6f 67 20 62 | 61 73 65 20 31 30 0d 0d |...log b|ase 10..|
|00001240| 4c 47 20 28 20 56 61 6c | 75 65 20 29 00 00 00 1d |LG ( Val|ue )....|
|00001250| 41 62 73 6f 6c 75 74 65 | 20 76 61 6c 75 65 0d 0d |Absolute| value..|
|00001260| 41 42 53 20 28 20 56 61 | 6c 75 65 20 29 00 00 01 |ABS ( Va|lue )...|
|00001270| 29 4d 61 63 72 6f 66 75 | 6e 63 74 69 6f 6e 20 66 |)Macrofu|nction f|
|00001280| 6f 72 20 74 68 65 20 6c | 69 73 74 69 6e 67 20 0d |or the l|isting .|
|00001290| 6f 66 20 76 61 72 69 6f | 75 73 20 61 73 73 69 67 |of vario|us assig|
|000012a0| 6e 6d 65 6e 74 73 20 0d | 73 70 61 6e 6e 69 6e 67 |nments .|spanning|
|000012b0| 20 6d 75 6c 74 69 70 6c | 65 20 6c 65 76 65 6c 73 | multipl|e levels|
|000012c0| 20 0d 28 6d 75 73 74 20 | 62 65 20 64 65 66 69 6e | .(must |be defin|
|000012d0| 65 64 20 69 6e 20 61 20 | 66 6c 65 78 69 62 6c 65 |ed in a |flexible|
|000012e0| 20 63 65 6c 6c 29 0d 0d | 45 58 50 41 4e 44 20 28 | cell)..|EXPAND (|
|000012f0| 46 5b 63 31 2e 2e 63 32 | 2c 72 31 2e 2e 72 32 5d |F[c1..c2|,r1..r2]|
|00001300| 3b 20 61 3b 20 30 3b 20 | 62 29 0d 20 0d 61 20 3d |; a; 0; |b). .a =|
|00001310| 20 50 61 67 65 20 6e 75 | 6d 62 65 72 3b 0d 62 20 | Page nu|mber;.b |
|00001320| 3d 20 30 20 52 65 70 65 | 74 69 74 69 6f 6e 20 6f |= 0 Repe|tition o|
|00001330| 66 20 61 74 74 72 69 62 | 75 74 65 73 3b 0d 62 20 |f attrib|utes;.b |
|00001340| 3d 20 31 20 4e 6f 20 72 | 65 70 65 74 69 74 69 6f |= 1 No r|epetitio|
|00001350| 6e 20 6f 66 20 61 74 74 | 72 69 62 75 74 65 73 3b |n of att|ributes;|
|00001360| 0d 46 5b 63 31 2e 2e 63 | 32 2c 72 31 2e 2e 72 32 |.F[c1..c|2,r1..r2|
|00001370| 5d 20 64 65 66 69 6e 65 | 73 20 72 61 6e 67 65 20 |] define|s range |
|00001380| 0d 77 68 65 72 65 20 6f | 75 74 70 75 74 20 69 73 |.where o|utput is|
|00001390| 20 64 69 73 70 6c 61 79 | 65 64 00 00 00 19 4e 61 | display|ed....Na|
|000013a0| 74 75 72 61 6c 20 6c 6f | 67 0d 0d 4c 4e 20 28 20 |tural lo|g..LN ( |
|000013b0| 56 61 6c 75 65 20 29 00 | 00 00 1b 53 71 75 61 72 |Value ).|...Squar|
|000013c0| 65 20 72 6f 6f 74 0d 0d | 53 51 52 54 20 28 20 56 |e root..|SQRT ( V|
|000013d0| 61 6c 75 65 20 29 00 00 | 00 1f 49 6e 74 65 67 65 |alue )..|..Intege|
|000013e0| 72 20 66 75 6e 63 74 69 | 6f 6e 0d 0d 49 4e 54 20 |r functi|on..INT |
|000013f0| 28 20 56 61 6c 75 65 20 | 29 00 00 00 5b 54 68 69 |( Value |)...[Thi|
|00001400| 73 20 65 6e 61 62 6c 65 | 73 20 74 68 65 20 75 73 |s enable|s the us|
|00001410| 65 72 20 20 20 20 20 20 | 20 20 20 0d 74 6f 20 63 |er      |   .to c|
|00001420| 68 6f 6f 73 65 20 61 64 | 64 69 74 69 6f 6e 61 6c |hoose ad|ditional|
|00001430| 20 20 20 20 20 20 20 20 | 20 20 20 0d 66 75 6e 63 |        |   .func|
|00001440| 74 69 6f 6e 73 20 74 68 | 61 74 20 61 72 65 20 61 |tions th|at are a|
|00001450| 76 61 69 6c 61 62 6c 65 | 00 00 00 a9 45 6e 61 62 |vailable|....Enab|
|00001460| 6c 65 73 20 74 68 65 20 | 75 73 65 72 20 74 6f 20 |les the |user to |
|00001470| 64 65 66 69 6e 65 20 61 | 6e 64 20 0d 72 65 63 61 |define a|nd .reca|
|00001480| 6c 6c 20 61 6e 20 61 73 | 73 69 67 6e 6d 65 6e 74 |ll an as|signment|
|00001490| 20 0d 0d 41 53 53 49 47 | 4e 4d 45 4e 54 3a 4e 4f | ..ASSIG|NMENT:NO|
|000014a0| 31 3a 0d 44 61 69 72 79 | 20 50 72 6f 64 75 63 74 |1:.Dairy| Product|
|000014b0| 73 20 3d 20 42 75 74 74 | 65 72 20 0d 6f 72 0d 0d |s = Butt|er .or..|
|000014c0| 53 61 6c 65 73 3a a5 50 | 72 6f 64 75 63 74 20 47 |Sales:.P|roduct G|
|000014d0| 72 6f 75 70 20 3d 20 0d | 53 55 4d 20 28 a5 50 72 |roup = .|SUM (.Pr|
|000014e0| 6f 64 75 63 74 73 3a 28 | 41 53 53 49 47 4e 4d 45 |oducts:(|ASSIGNME|
|000014f0| 4e 54 3a 0d a5 50 72 6f | 64 75 63 74 20 47 72 6f |NT:..Pro|duct Gro|
|00001500| 75 70 29 29 0d 00 00 00 | 5e 44 65 66 69 6e 65 73 |up))....|^Defines|
|00001510| 20 61 6c 6c 20 74 68 65 | 20 61 74 74 72 69 62 75 | all the| attribu|
|00001520| 74 65 73 20 0d 69 6e 20 | 61 20 67 69 76 65 6e 20 |tes .in |a given |
|00001530| 67 72 6f 75 70 0d 0d a5 | 50 72 6f 64 75 63 74 3a |group...|Product:|
|00001540| 28 41 4c 4c 29 0d 6f 72 | 0d 53 61 6c 65 73 20 3d |(ALL).or|.Sales =|
|00001550| 20 53 55 4d 20 0d 28 a5 | 50 72 6f 64 75 63 74 3a | SUM .(.|Product:|
|00001560| 28 41 4c 4c 29 29 0d 00 | 00 00 b0 53 75 6d 6d 61 |(ALL))..|...Summa|
|00001570| 74 69 6f 6e 20 46 75 6e | 63 74 69 6f 6e 0d 0d 53 |tion Fun|ction..S|
|00001580| 55 4d 20 28 20 46 5b 31 | 2e 2e 31 30 2c 34 5d 20 |UM ( F[1|..10,4] |
|00001590| 29 0d 6f 72 0d 53 61 6c | 65 73 3a 31 2f 39 30 20 |).or.Sal|es:1/90 |
|000015a0| 3d 20 53 55 4d 28 20 a5 | 50 72 6f 64 75 63 74 0d |= SUM( .|Product.|
|000015b0| 3a 28 61 6c 6c 29 3a 53 | 61 6c 65 73 3a 31 2f 39 |:(all):S|ales:1/9|
|000015c0| 30 20 29 0d 6f 72 0d 53 | 61 6c 65 73 3a a5 50 72 |0 ).or.S|ales:.Pr|
|000015d0| 6f 64 75 63 74 20 47 72 | 6f 75 70 73 3a 31 2f 39 |oduct Gr|oups:1/9|
|000015e0| 30 20 3d 0d 53 55 4d 28 | 20 a5 50 72 6f 64 75 63 |0 =.SUM(| .Produc|
|000015f0| 74 3a 28 41 73 73 69 67 | 6e 6d 65 6e 74 0d 3a a5 |t:(Assig|nment.:.|
|00001600| 50 72 6f 64 75 63 74 20 | 47 72 6f 75 70 73 29 3a |Product |Groups):|
|00001610| 53 61 6c 65 73 3a 31 2f | 39 30 29 00 00 00 5e 44 |Sales:1/|90)...^D|
|00001620| 65 66 69 6e 65 73 20 61 | 6c 6c 20 74 68 65 20 61 |efines a|ll the a|
|00001630| 74 74 72 69 62 75 74 65 | 73 20 0d 69 6e 20 61 20 |ttribute|s .in a |
|00001640| 67 69 76 65 6e 20 67 72 | 6f 75 70 0d 0d a5 50 72 |given gr|oup...Pr|
|00001650| 6f 64 75 63 74 3a 28 41 | 4c 4c 29 0d 6f 72 0d 53 |oduct:(A|LL).or.S|
|00001660| 61 6c 65 73 20 3d 20 53 | 55 4d 20 0d 28 a5 50 72 |ales = S|UM .(.Pr|
|00001670| 6f 64 75 63 74 3a 28 41 | 4c 4c 29 29 0d 00 00 00 |oduct:(A|LL))....|
|00001680| a9 45 6e 61 62 6c 65 73 | 20 74 68 65 20 75 73 65 |.Enables| the use|
|00001690| 72 20 74 6f 20 64 65 66 | 69 6e 65 20 61 6e 64 20 |r to def|ine and |
|000016a0| 0d 72 65 63 61 6c 6c 20 | 61 6e 20 61 73 73 69 67 |.recall |an assig|
|000016b0| 6e 6d 65 6e 74 20 0d 0d | 41 53 53 49 47 4e 4d 45 |nment ..|ASSIGNME|
|000016c0| 4e 54 3a 4e 4f 31 3a 0d | 44 61 69 72 79 20 50 72 |NT:NO1:.|Dairy Pr|
|000016d0| 6f 64 75 63 74 73 20 3d | 20 42 75 74 74 65 72 20 |oducts =| Butter |
|000016e0| 0d 6f 72 0d 0d 53 61 6c | 65 73 3a a5 50 72 6f 64 |.or..Sal|es:.Prod|
|000016f0| 75 63 74 20 47 72 6f 75 | 70 20 3d 20 0d 53 55 4d |uct Grou|p = .SUM|
|00001700| 20 28 a5 50 72 6f 64 75 | 63 74 73 3a 28 41 53 53 | (.Produ|cts:(ASS|
|00001710| 49 47 4e 4d 45 4e 54 3a | 0d a5 50 72 6f 64 75 63 |IGNMENT:|..Produc|
|00001720| 74 20 47 72 6f 75 70 29 | 29 0d 00 00 00 88 53 75 |t Group)|).....Su|
|00001730| 6d 73 20 75 70 20 64 61 | 74 61 20 76 61 6c 75 65 |ms up da|ta value|
|00001740| 73 20 66 6f 72 20 0d 61 | 20 73 70 65 63 69 66 69 |s for .a| specifi|
|00001750| 63 20 70 65 72 69 6f 64 | 20 6f 66 20 74 69 6d 65 |c period| of time|
|00001760| 0d 0d 54 6f 74 61 6c 20 | 53 61 6c 65 73 20 3a 20 |..Total |Sales : |
|00001770| a5 50 72 6f 64 75 63 74 | 73 20 3d 0d 54 49 4d 45 |.Product|s =.TIME|
|00001780| 53 55 4d 28 20 53 61 6c | 65 73 3a a5 50 72 6f 64 |SUM( Sal|es:.Prod|
|00001790| 75 63 74 73 0d 3a 31 2f | 31 39 30 34 61 3b 20 53 |ucts.:1/|1904a; S|
|000017a0| 74 61 72 74 20 74 69 6d | 65 3b 20 0d 45 6e 64 20 |tart tim|e; .End |
|000017b0| 74 69 6d 65 20 29 00 00 | 00 ad 4d 61 6b 65 73 20 |time )..|..Makes |
|000017c0| 70 6f 73 73 69 62 6c 65 | 20 0d 63 6f 6e 64 69 74 |possible| .condit|
|000017d0| 69 6f 6e 61 6c 20 63 61 | 6c 63 75 6c 61 74 69 6f |ional ca|lculatio|
|000017e0| 6e 73 0d 0d 49 46 20 28 | 20 46 5b 63 31 2c 72 31 |ns..IF (| F[c1,r1|
|000017f0| 5d 20 3e 20 46 5b 63 32 | 2c 72 32 5d 20 29 20 54 |] > F[c2|,r2] ) T|
|00001800| 48 45 4e 20 0d 28 20 46 | 5b 63 33 2c 72 33 5d 20 |HEN .( F|[c3,r3] |
|00001810| 29 20 45 4c 53 45 20 28 | 20 46 5b 63 34 2c 72 34 |) ELSE (| F[c4,r4|
|00001820| 5d 20 29 0d 0d 6f 72 0d | 49 46 20 28 20 a5 50 72 |] )..or.|IF ( .Pr|
|00001830| 6f 64 75 63 74 3a 53 61 | 6c 65 73 3a 31 2f 39 30 |oduct:Sa|les:1/90|
|00001840| 20 3c 20 31 30 30 30 20 | 29 0d 54 48 45 4e 20 28 | < 1000 |).THEN (|
|00001850| 20 54 61 78 20 31 20 29 | 20 45 4c 53 45 20 28 20 | Tax 1 )| ELSE ( |
|00001860| 54 61 78 20 32 20 29 00 | 00 00 78 43 68 61 6e 67 |Tax 2 ).|..xChang|
|00001870| 65 73 20 61 6e 79 20 74 | 69 6d 65 20 72 65 66 65 |es any t|ime refe|
|00001880| 72 65 6e 63 65 20 0d 69 | 6e 74 6f 20 61 20 6d 6f |rence .i|nto a mo|
|00001890| 6e 74 68 6c 79 20 74 69 | 6d 65 20 72 65 66 65 72 |nthly ti|me refer|
|000018a0| 65 6e 63 65 20 0d 0d 4d | 4f 4e 54 48 20 28 20 44 |ence ..M|ONTH ( D|
|000018b0| 61 74 65 20 29 0d 0d 28 | 66 6f 72 20 65 78 61 6d |ate )..(|for exam|
|000018c0| 70 6c 65 2c 20 31 39 39 | 31 20 6f 72 20 31 2f 31 |ple, 199|1 or 1/1|
|000018d0| 33 2f 39 31 0d 62 65 63 | 6f 6d 65 73 20 31 2f 39 |3/91.bec|omes 1/9|
|000018e0| 31 20 29 00 00 00 7c 58 | 54 49 4d 45 20 28 30 29 |1 )...|X|TIME (0)|
|000018f0| 20 72 65 70 72 65 73 65 | 6e 74 73 20 74 68 65 20 | represe|nts the |
|00001900| 70 6f 69 6e 74 20 6f 66 | 20 0d 74 69 6d 65 20 61 |point of| .time a|
|00001910| 73 20 64 65 66 69 6e 65 | 64 20 69 6e 20 74 68 65 |s define|d in the|
|00001920| 20 63 65 6c 6c 0d 0d 53 | 61 6c 65 73 3a 31 2f 39 | cell..S|ales:1/9|
|00001930| 30 20 3d 20 49 46 20 28 | 58 54 49 4d 45 20 28 30 |0 = IF (|XTIME (0|
|00001940| 29 20 3e 0d 35 2f 39 30 | 29 20 54 48 45 4e 20 28 |) >.5/90|) THEN (|
|00001950| 20 2e 2e 2e 20 29 20 45 | 4c 53 45 20 28 20 2e 2e | ... ) E|LSE ( ..|
|00001960| 2e 20 29 00 00 00 d6 41 | 6c 6c 6f 77 73 20 66 6f |. )....A|llows fo|
|00001970| 72 20 61 6e 20 61 74 74 | 72 69 62 75 74 65 20 74 |r an att|ribute t|
|00001980| 6f 20 62 65 20 75 73 65 | 64 0d 61 73 20 61 6e 20 |o be use|d.as an |
|00001990| 61 74 74 72 69 62 75 74 | 65 2c 20 69 6e 73 74 65 |attribut|e, inste|
|000019a0| 61 64 20 6f 66 20 61 20 | 0d 64 61 74 61 62 61 73 |ad of a |.databas|
|000019b0| 65 20 64 65 66 69 6e 69 | 74 69 6f 6e 0d 0d a5 53 |e defini|tion...S|
|000019c0| 74 6f 72 65 73 3a 20 53 | 61 6c 65 73 20 3d 20 49 |tores: S|ales = I|
|000019d0| 46 20 28 a5 53 74 6f 72 | 65 73 3a 0d 6d 61 67 6e |F (.Stor|es:.magn|
|000019e0| 69 74 75 64 65 20 3d 20 | 41 54 54 52 49 42 55 54 |itude = |ATTRIBUT|
|000019f0| 45 20 28 6c 61 72 67 65 | 29 29 20 0d 54 48 45 4e |E (large|)) .THEN|
|00001a00| 20 28 20 2e 2e 2e 20 29 | 20 45 4c 53 45 20 28 20 | ( ... )| ELSE ( |
|00001a10| 2e 2e 2e 20 29 0d 0d 28 | 20 6c 61 72 67 65 20 69 |... )..(| large i|
|00001a20| 73 20 69 6e 20 74 68 69 | 73 20 63 61 73 65 20 61 |s in thi|s case a|
|00001a30| 6e 20 61 74 74 72 69 62 | 75 74 65 20 29 00 00 00 |n attrib|ute )...|
|00001a40| 5e 45 4d 50 54 59 20 28 | 30 29 20 72 65 70 72 65 |^EMPTY (|0) repre|
|00001a50| 73 65 6e 74 73 0d 61 6e | 20 65 6d 70 74 79 20 66 |sents.an| empty f|
|00001a60| 69 65 6c 64 0d 0d 49 46 | 20 28 20 46 5b 63 31 2c |ield..IF| ( F[c1,|
|00001a70| 72 31 5d 20 3d 20 45 4d | 50 54 59 20 28 30 29 20 |r1] = EM|PTY (0) |
|00001a80| 29 20 0d 54 48 45 4e 20 | 28 20 30 20 29 20 45 4c |) .THEN |( 0 ) EL|
|00001a90| 53 45 20 28 20 46 5b 63 | 32 2c 72 32 5d 20 29 00 |SE ( F[c|2,r2] ).|
|00001aa0| 00 00 bc 54 68 69 73 20 | 66 75 6e 63 74 69 6f 6e |...This |function|
|00001ab0| 20 64 65 74 65 72 6d 69 | 6e 65 73 20 74 68 65 20 | determi|nes the |
|00001ac0| 6e 75 6d 62 65 72 0d 6f | 66 20 66 69 65 6c 64 73 |number.o|f fields|
|00001ad0| 20 77 68 69 63 68 20 61 | 72 65 20 69 6e 20 61 20 | which a|re in a |
|00001ae0| 67 69 76 65 6e 20 72 61 | 6e 67 65 2c 0d 6f 72 20 |given ra|nge,.or |
|00001af0| 74 68 65 20 6e 75 6d 62 | 65 72 20 6f 66 20 61 74 |the numb|er of at|
|00001b00| 74 72 69 62 75 74 65 73 | 20 69 6e 20 61 0d 67 69 |tributes| in a.gi|
|00001b10| 76 65 6e 20 64 61 74 61 | 62 61 73 65 20 73 65 6c |ven data|base sel|
|00001b20| 65 63 74 69 6f 6e 0d 0d | 43 4f 55 4e 54 41 4c 4c |ection..|COUNTALL|
|00001b30| 28 20 46 5b 63 2c 72 31 | 2e 2e 72 32 5d 20 29 0d |( F[c,r1|..r2] ).|
|00001b40| 0d 6f 72 0d 43 4f 55 4e | 54 41 4c 4c 28 20 a5 50 |.or.COUN|TALL( .P|
|00001b50| 72 6f 64 75 63 74 73 3a | 28 61 6c 6c 29 20 29 00 |roducts:|(all) ).|
|00001b60| 00 01 16 54 68 69 73 20 | 66 75 6e 63 74 69 6f 6e |...This |function|
|00001b70| 20 64 65 74 65 72 6d 69 | 6e 65 73 20 74 68 65 20 | determi|nes the |
|00001b80| 6e 75 6d 62 65 72 0d 6f | 66 20 66 69 65 6c 64 73 |number.o|f fields|
|00001b90| 20 69 6e 20 61 20 67 69 | 76 65 6e 20 72 61 6e 67 | in a gi|ven rang|
|00001ba0| 65 2c 0d 6f 72 20 74 68 | 65 20 6e 75 6d 62 65 72 |e,.or th|e number|
|00001bb0| 20 6f 66 20 61 74 74 72 | 69 62 75 74 65 73 20 69 | of attr|ibutes i|
|00001bc0| 6e 20 61 0d 67 69 76 65 | 6e 20 64 61 74 61 62 61 |n a.give|n databa|
|00001bd0| 73 65 20 73 65 6c 65 63 | 74 69 6f 6e 2c 20 74 61 |se selec|tion, ta|
|00001be0| 6b 69 6e 67 20 69 6e 74 | 6f 20 0d 63 6f 6e 73 69 |king int|o .consi|
|00001bf0| 64 65 72 61 74 69 6f 6e | 20 6f 6e 6c 79 20 74 68 |deration| only th|
|00001c00| 6f 73 65 20 63 65 6c 6c | 73 20 74 68 61 74 20 0d |ose cell|s that .|
|00001c10| 61 72 65 20 6e 6f 74 20 | 65 6d 70 74 79 0d 0d 43 |are not |empty..C|
|00001c20| 4f 55 4e 54 56 41 4c 55 | 45 28 20 46 5b 63 2c 72 |OUNTVALU|E( F[c,r|
|00001c30| 31 2e 2e 72 32 5d 20 29 | 0d 0d 6f 72 0d 43 4f 55 |1..r2] )|..or.COU|
|00001c40| 4e 54 56 41 4c 55 45 28 | a5 50 72 6f 64 75 63 74 |NTVALUE(|.Product|
|00001c50| 73 3a 28 61 6c 6c 29 3a | 0d 20 20 20 20 20 20 20 |s:(all):|.       |
|00001c60| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00001c70| 20 20 20 53 61 6c 65 73 | 29 00 00 00 76 54 68 65 |   Sales|)...vThe|
|00001c80| 20 6d 6f 73 74 20 73 70 | 65 63 69 66 69 63 20 65 | most sp|ecific e|
|00001c90| 6c 65 6d 65 6e 74 20 6f | 66 20 0d 61 20 74 69 6d |lement o|f .a tim|
|00001ca0| 65 20 72 65 66 65 72 65 | 6e 63 65 20 62 65 63 6f |e refere|nce beco|
|00001cb0| 6d 65 73 20 0d 61 20 6e | 75 6d 65 72 69 63 61 6c |mes .a n|umerical|
|00001cc0| 20 76 61 6c 75 65 0d 0d | 50 45 52 49 4f 44 20 28 | value..|PERIOD (|
|00001cd0| 33 2f 39 30 29 20 62 65 | 63 6f 6d 65 73 20 33 3b |3/90) be|comes 3;|
|00001ce0| 0d 28 31 2f 33 2f 39 31 | 29 20 62 65 63 6f 6d 65 |.(1/3/91|) become|
|00001cf0| 73 20 31 00 00 00 69 47 | 69 76 65 73 20 74 68 65 |s 1...iG|ives the|
|00001d00| 20 63 75 72 72 65 6e 74 | 20 64 61 74 65 20 0d 6f | current| date .o|
|00001d10| 72 20 74 68 65 20 63 75 | 72 72 65 6e 74 20 74 69 |r the cu|rrent ti|
|00001d20| 6d 65 0d 0d 44 41 54 45 | 54 49 4d 45 20 28 30 29 |me..DATE|TIME (0)|
|00001d30| 20 67 69 76 65 73 20 74 | 68 65 20 64 61 74 65 0d | gives t|he date.|
|00001d40| 0d 6f 72 0d 44 41 54 45 | 54 49 4d 45 20 28 31 29 |.or.DATE|TIME (1)|
|00001d50| 20 67 69 76 65 73 20 74 | 68 65 20 74 69 6d 65 0d | gives t|he time.|
|00001d60| 00 00 00 2d 43 68 61 6e | 67 65 73 20 61 6e 79 20 |...-Chan|ges any |
|00001d70| 64 61 74 61 20 74 79 70 | 65 20 74 6f 20 74 65 78 |data typ|e to tex|
|00001d80| 74 0d 0d 54 45 58 54 20 | 28 20 56 61 6c 75 65 20 |t..TEXT |( Value |
|00001d90| 29 00 00 00 74 41 64 64 | 73 20 74 77 6f 20 63 65 |)...tAdd|s two ce|
|00001da0| 6c 6c 73 20 74 6f 67 65 | 74 68 65 72 2c 20 61 73 |lls toge|ther, as|
|00001db0| 20 6c 6f 6e 67 20 61 73 | 0d 62 6f 74 68 20 63 65 | long as|.both ce|
|00001dc0| 6c 6c 73 20 61 72 65 20 | 6e 6f 74 20 45 4d 50 54 |lls are |not EMPT|
|00001dd0| 59 3b 20 6f 74 68 65 72 | 77 69 73 65 2c 0d 74 68 |Y; other|wise,.th|
|00001de0| 65 20 72 65 73 75 6c 74 | 20 69 73 20 45 4d 50 54 |e result| is EMPT|
|00001df0| 59 20 0d 0d 56 61 6c 75 | 65 20 31 20 50 4c 55 53 |Y ..Valu|e 1 PLUS|
|00001e00| 20 56 61 6c 75 65 20 32 | 20 00 00 00 7e 53 75 62 | Value 2| ...~Sub|
|00001e10| 74 72 61 63 74 73 20 6f | 6e 65 20 63 65 6c 6c 20 |tracts o|ne cell |
|00001e20| 66 72 6f 6d 20 61 6e 6f | 74 68 65 72 2c 20 0d 61 |from ano|ther, .a|
|00001e30| 73 20 6c 6f 6e 67 20 61 | 73 20 62 6f 74 68 20 63 |s long a|s both c|
|00001e40| 65 6c 6c 73 20 61 72 65 | 20 6e 6f 74 20 45 4d 50 |ells are| not EMP|
|00001e50| 54 59 3b 20 0d 6f 74 68 | 65 72 77 69 73 65 2c 20 |TY; .oth|erwise, |
|00001e60| 74 68 65 20 72 65 73 75 | 6c 74 20 69 73 20 45 4d |the resu|lt is EM|
|00001e70| 50 54 59 0d 0d 56 61 6c | 75 65 20 31 20 4d 49 4e |PTY..Val|ue 1 MIN|
|00001e80| 55 53 20 56 61 6c 75 65 | 20 32 20 00 00 00 19 6c |US Value| 2 ....l|
|00001e90| 6f 67 20 62 61 73 65 20 | 31 30 0d 0d 4c 47 20 28 |og base |10..LG (|
|00001ea0| 20 56 61 6c 75 65 20 29 | 00 00 00 1d 41 62 73 6f | Value )|....Abso|
|00001eb0| 6c 75 74 65 20 76 61 6c | 75 65 0d 0d 41 42 53 20 |lute val|ue..ABS |
|00001ec0| 28 20 56 61 6c 75 65 20 | 29 00 00 00 5b 54 68 69 |( Value |)...[Thi|
|00001ed0| 73 20 65 6e 61 62 6c 65 | 73 20 74 68 65 20 75 73 |s enable|s the us|
|00001ee0| 65 72 20 20 20 20 20 20 | 20 20 20 0d 74 6f 20 63 |er      |   .to c|
|00001ef0| 68 6f 6f 73 65 20 61 64 | 64 69 74 69 6f 6e 61 6c |hoose ad|ditional|
|00001f00| 20 20 20 20 20 20 20 20 | 20 20 20 0d 66 75 6e 63 |        |   .func|
|00001f10| 74 69 6f 6e 73 20 74 68 | 61 74 20 61 72 65 20 61 |tions th|at are a|
|00001f20| 76 61 69 6c 61 62 6c 65 | 00 00 00 88 54 68 69 73 |vailable|....This|
|00001f30| 20 66 75 6e 63 74 69 6f | 6e 20 61 6c 6c 6f 77 73 | functio|n allows|
|00001f40| 20 74 68 65 20 75 73 65 | 72 20 74 6f 20 61 64 64 | the use|r to add|
|00001f50| 0d 74 65 78 74 20 74 6f | 20 61 20 6d 61 63 72 6f |.text to| a macro|
|00001f60| 66 6f 72 6d 75 6c 61 0d | 0d 0d 4d 61 63 72 6f 66 |formula.|..Macrof|
|00001f70| 6f 72 6d 75 6c 61 3a 4e | 4f 69 3a 28 57 6f 72 6b |ormula:N|Oi:(Work|
|00001f80| 73 68 65 65 74 29 20 3d | 0d 41 55 54 4f 41 53 53 |sheet) =|.AUTOASS|
|00001f90| 49 47 4e 4d 45 4e 54 28 | 2e 2e 2e 20 29 0d 2b 22 |IGNMENT(|... ).+"|
|00001fa0| 20 43 72 65 61 74 65 20 | 41 73 73 69 67 6e 6d 65 | Create |Assignme|
|00001fb0| 6e 74 20 22 00 00 00 f4 | 48 65 6c 70 73 20 74 6f |nt "....|Helps to|
|00001fc0| 20 64 65 66 69 6e 65 20 | 74 68 65 20 74 69 6d 65 | define |the time|
|00001fd0| 20 72 61 6e 67 65 20 66 | 6f 72 20 0d 66 75 6e 63 | range f|or .func|
|00001fe0| 74 69 6f 6e 73 20 77 68 | 69 63 68 20 63 61 72 72 |tions wh|ich carr|
|00001ff0| 79 20 6f 75 74 20 0d 74 | 69 6d 65 20 72 61 6e 67 |y out .t|ime rang|
|00002000| 65 20 6f 70 65 72 61 74 | 69 6f 6e 73 0d 0d 41 53 |e operat|ions..AS|
|00002010| 53 49 47 4e 4d 45 4e 54 | 3a 4e 4f 69 3a 28 57 6f |SIGNMENT|:NOi:(Wo|
|00002020| 72 6b 73 68 65 65 74 29 | 20 3d 0d 41 55 54 4f 41 |rksheet)| =.AUTOA|
|00002030| 53 53 49 47 4e 4d 45 4e | 54 28 a5 44 65 70 61 72 |SSIGNMEN|T(.Depar|
|00002040| 74 6d 65 6e 74 73 3b 0d | a5 44 65 70 61 72 74 6d |tments;.|.Departm|
|00002050| 65 6e 74 73 3a 43 6f 73 | 74 73 3a 0d 31 2f 39 30 |ents:Cos|ts:.1/90|
|00002060| 20 74 6f 20 31 32 2f 39 | 32 29 20 20 0d 0d 6f 72 | to 12/9|2)  ..or|
|00002070| 0d a5 50 72 6f 64 75 63 | 74 73 3a 53 61 6c 65 73 |..Produc|ts:Sales|
|00002080| 20 54 6f 74 61 6c 20 3d | 0d 53 55 4d 28 a5 50 72 | Total =|.SUM(.Pr|
|00002090| 6f 64 75 63 74 73 3a 53 | 61 6c 65 73 3a 0d 31 2f |oducts:S|ales:.1/|
|000020a0| 39 30 20 74 6f 20 31 32 | 2f 39 31 29 00 00 00 c7 |90 to 12|/91)....|
|000020b0| 4d 61 63 72 6f 66 75 6e | 63 74 69 6f 6e 20 74 68 |Macrofun|ction th|
|000020c0| 61 74 20 65 6e 61 62 6c | 65 73 20 74 68 65 20 75 |at enabl|es the u|
|000020d0| 73 65 72 0d 74 6f 20 61 | 75 74 6f 6d 61 74 69 63 |ser.to a|utomatic|
|000020e0| 61 6c 6c 79 20 70 72 69 | 6e 74 20 61 20 67 69 76 |ally pri|nt a giv|
|000020f0| 65 6e 20 73 65 74 20 6f | 66 0d 70 61 67 65 73 0d |en set o|f.pages.|
|00002100| 0d 4d 61 63 72 6f 66 6f | 72 6d 75 6c 61 20 3a 20 |.Macrofo|rmula : |
|00002110| 4e 4f 69 20 3a 20 28 57 | 6f 72 6b 73 68 65 65 74 |NOi : (W|orksheet|
|00002120| 29 20 3d 20 0d 41 55 54 | 4f 50 52 49 4e 54 20 28 |) = .AUT|OPRINT (|
|00002130| 20 46 5b 63 31 2e 2e 63 | 32 2c 72 31 2e 2e 72 32 | F[c1..c|2,r1..r2|
|00002140| 5d 20 29 0d 0d 28 46 5b | 63 31 2e 2e 63 32 2c 72 |] )..(F[|c1..c2,r|
|00002150| 31 2e 2e 72 32 5d 20 64 | 65 66 69 6e 65 73 20 74 |1..r2] d|efines t|
|00002160| 68 65 20 70 61 67 65 73 | 0d 74 6f 20 62 65 20 70 |he pages|.to be p|
|00002170| 72 69 6e 74 65 64 29 00 | 00 00 c4 4d 61 63 72 6f |rinted).|...Macro|
|00002180| 66 75 6e 63 74 69 6f 6e | 20 74 68 61 74 20 69 6d |function| that im|
|00002190| 70 6f 72 74 73 20 0d 61 | 20 74 65 78 74 20 66 69 |ports .a| text fi|
|000021a0| 6c 65 0d 0d 4d 41 43 52 | 4f 46 55 4e 43 54 49 4f |le..MACR|OFUNCTIO|
|000021b0| 4e 3a 20 4e 4f 69 3a 20 | 28 57 6f 72 6b 73 68 65 |N: NOi: |(Workshe|
|000021c0| 65 74 29 20 3d 0d 41 55 | 54 4f 49 4d 50 4f 52 54 |et) =.AU|TOIMPORT|
|000021d0| 28 20 46 5b 63 31 2e 2e | 63 32 2c 72 31 2e 2e 72 |( F[c1..|c2,r1..r|
|000021e0| 32 5d 3b 0d 20 20 20 20 | 20 20 20 20 20 20 20 20 |2];.    |        |
|000021f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 30 20 6f |        |     0 o|
|00002200| 72 20 46 69 6c 65 20 6e | 61 6d 65 3b 30 20 29 0d |r File n|ame;0 ).|
|00002210| 0d 28 20 46 5b 63 31 2e | 2e 63 32 2c 72 31 2e 2e |.( F[c1.|.c2,r1..|
|00002220| 72 32 5d 20 64 65 66 69 | 6e 65 73 20 74 68 65 20 |r2] defi|nes the |
|00002230| 0d 69 6d 70 6f 72 74 20 | 66 6f 72 6d 61 74 29 00 |.import |format).|
|00002240| 00 01 32 4d 61 63 72 6f | 66 75 6e 63 74 69 6f 6e |..2Macro|function|
|00002250| 20 74 68 61 74 20 65 78 | 70 6f 72 74 73 20 0d 64 | that ex|ports .d|
|00002260| 61 74 61 20 74 6f 20 61 | 20 74 65 78 74 20 66 69 |ata to a| text fi|
|00002270| 6c 65 0d 0d 4d 41 43 52 | 4f 46 55 4e 43 54 49 4f |le..MACR|OFUNCTIO|
|00002280| 4e 3a 20 4e 4f 69 20 20 | 3d 20 41 55 54 4f 45 58 |N: NOi  |= AUTOEX|
|00002290| 50 4f 52 54 0d 28 47 65 | 6e 65 72 61 6c 69 7a 65 |PORT.(Ge|neralize|
|000022a0| 64 20 49 6e 70 75 74 20 | 56 61 6c 75 65 3b 20 53 |d Input |Value; S|
|000022b0| 65 6c 65 63 74 69 6f 6e | 20 6f 72 20 30 3b 0d 20 |election| or 0;. |
|000022c0| 46 69 6c 65 20 6e 61 6d | 65 20 6f 72 20 30 3b 20 |File nam|e or 0; |
|000022d0| 30 3b 20 45 78 70 6f 72 | 74 20 66 6f 72 6d 61 74 |0; Expor|t format|
|000022e0| 20 6f 72 20 30 29 0d 0d | 28 20 30 20 69 6e 73 74 | or 0)..|( 0 inst|
|000022f0| 65 61 64 20 6f 66 20 73 | 65 6c 65 63 74 69 6f 6e |ead of s|election|
|00002300| 20 3a 20 6e 6f 20 73 65 | 6c 65 63 74 69 6f 6e 3b | : no se|lection;|
|00002310| 0d 20 20 30 20 69 6e 73 | 74 65 61 64 20 6f 66 20 |.  0 ins|tead of |
|00002320| 66 69 6c 65 20 6e 61 6d | 65 20 3a 20 6d 61 6e 75 |file nam|e : manu|
|00002330| 61 6c 20 66 69 6c 65 20 | 73 65 6c 65 63 74 69 6f |al file |selectio|
|00002340| 6e 3b 0d 20 20 30 20 69 | 6e 73 74 65 61 64 20 6f |n;.  0 i|nstead o|
|00002350| 66 20 65 78 70 6f 72 74 | 20 66 6f 72 6d 61 74 20 |f export| format |
|00002360| 3a 20 73 74 61 6e 64 61 | 72 64 20 66 6f 72 6d 61 |: standa|rd forma|
|00002370| 74 20 29 0d 0d 00 00 01 | 13 4d 61 63 72 6f 66 75 |t ).....|.Macrofu|
|00002380| 6e 63 74 69 6f 6e 20 66 | 6f 72 20 0d 63 72 65 61 |nction f|or .crea|
|00002390| 74 69 6e 67 20 61 73 73 | 69 67 6e 6d 65 6e 74 73 |ting ass|ignments|
|000023a0| 20 0d 0d 4d 41 43 52 4f | 46 55 4e 43 54 49 4f 4e | ..MACRO|FUNCTION|
|000023b0| 3a 4e 4f 69 20 3d 0d 41 | 55 54 4f 41 53 53 49 47 |:NOi =.A|UTOASSIG|
|000023c0| 4e 4d 45 4e 54 20 0d 28 | 6c 65 66 74 20 73 69 64 |NMENT .(|left sid|
|000023d0| 65 20 6f 66 20 61 73 73 | 69 67 6e 6d 65 6e 74 3b |e of ass|ignment;|
|000023e0| 20 47 72 6f 75 70 20 74 | 6f 20 0d 62 65 20 61 73 | Group t|o .be as|
|000023f0| 73 69 67 6e 65 64 3b 20 | 47 65 6e 65 72 61 6c 69 |signed; |Generali|
|00002400| 7a 65 64 0d 49 6e 70 75 | 74 20 56 61 6c 75 65 29 |zed.Inpu|t Value)|
|00002410| 0d 0d 6f 72 0d 4d 41 43 | 52 4f 46 55 4e 43 54 49 |..or.MAC|ROFUNCTI|
|00002420| 4f 4e 3a 4e 4f 69 20 3d | 0d 41 55 54 4f 41 53 53 |ON:NOi =|.AUTOASS|
|00002430| 49 47 4e 4d 45 4e 54 20 | 0d 28 4c 65 66 74 20 73 |IGNMENT |.(Left s|
|00002440| 69 64 65 20 6f 66 20 61 | 73 73 69 67 6e 6d 65 6e |ide of a|ssignmen|
|00002450| 74 3b 20 47 72 6f 75 70 | 20 74 6f 0d 62 65 20 61 |t; Group| to.be a|
|00002460| 73 73 69 67 6e 65 64 3b | 20 47 65 6e 65 72 61 6c |ssigned;| General|
|00002470| 69 7a 65 64 20 49 6e 70 | 75 74 0d 56 61 6c 75 65 |ized Inp|ut.Value|
|00002480| 3b 20 53 65 6c 65 63 74 | 69 6f 6e 29 00 00 00 85 |; Select|ion)....|
|00002490| 4d 61 63 72 6f 66 75 6e | 63 74 69 6f 6e 20 74 68 |Macrofun|ction th|
|000024a0| 61 74 20 64 65 6c 65 74 | 65 73 20 61 6c 6c 0d 64 |at delet|es all.d|
|000024b0| 61 74 61 62 61 73 65 20 | 76 61 6c 75 65 73 20 6f |atabase |values o|
|000024c0| 66 20 61 20 67 69 76 65 | 6e 0d 67 65 6e 65 72 61 |f a give|n.genera|
|000024d0| 6c 69 7a 61 74 69 6f 6e | 0d 0d 4d 41 43 52 4f 46 |lization|..MACROF|
|000024e0| 55 4e 43 54 49 4f 4e 3a | 4e 4f 69 20 3d 0d 44 45 |UNCTION:|NOi =.DE|
|000024f0| 4c 45 54 45 20 28 20 47 | 65 6e 65 72 61 6c 69 7a |LETE ( G|eneraliz|
|00002500| 65 64 20 49 6e 70 75 74 | 0d 56 61 6c 75 65 3b 30 |ed Input|.Value;0|
|00002510| 20 3b 30 20 29 00 00 01 | 01 4d 61 63 72 6f 66 75 | ;0 )...|.Macrofu|
|00002520| 6e 63 74 69 6f 6e 20 66 | 6f 72 20 74 68 65 20 73 |nction f|or the s|
|00002530| 6f 72 74 69 6e 67 0d 6f | 66 20 61 73 73 69 67 6e |orting.o|f assign|
|00002540| 6d 65 6e 74 73 0d 0d 4d | 41 43 52 4f 46 55 4e 43 |ments..M|ACROFUNC|
|00002550| 54 49 4f 4e 3a 20 4e 4f | 69 20 3d 0d 41 55 54 4f |TION: NO|i =.AUTO|
|00002560| 53 4f 52 54 28 20 44 65 | 66 69 6e 69 74 69 6f 6e |SORT( De|finition|
|00002570| 20 6f 66 20 0d 61 73 73 | 69 67 6e 6d 65 6e 74 3b | of .ass|ignment;|
|00002580| 20 53 6f 72 74 69 6e 67 | 20 63 72 69 74 65 72 69 | Sorting| criteri|
|00002590| 6f 6e 20 0d 6f 72 20 30 | 20 3b 20 6e 20 29 0d 0d |on .or 0| ; n )..|
|000025a0| 28 20 30 20 49 6e 73 74 | 65 61 64 20 6f 66 20 73 |( 0 Inst|ead of s|
|000025b0| 6f 72 74 69 6e 67 20 63 | 72 69 74 65 72 69 6f 6e |orting c|riterion|
|000025c0| 20 3a 20 0d 20 20 20 20 | 20 41 6c 70 68 61 6e 75 | : .    | Alphanu|
|000025d0| 6d 65 72 69 63 20 73 6f | 72 74 69 6e 67 3b 0d 20 |meric so|rting;. |
|000025e0| 20 6e 20 3d 20 31 20 41 | 73 63 65 6e 64 69 6e 67 | n = 1 A|scending|
|000025f0| 20 73 6f 72 74 69 6e 67 | 3b 0d 20 20 6e 20 3d 20 | sorting|;.  n = |
|00002600| 32 20 44 65 73 63 65 6e | 64 69 6e 67 20 20 73 6f |2 Descen|ding  so|
|00002610| 72 74 69 6e 67 20 29 0d | 20 20 00 00 00 ff 43 6f |rting ).|  ....Co|
|00002620| 6d 62 69 6e 65 73 20 6d | 75 6c 74 69 70 6c 65 20 |mbines m|ultiple |
|00002630| 4d 61 63 72 6f 20 66 6f | 72 6d 75 6c 61 73 20 0d |Macro fo|rmulas .|
|00002640| 69 6e 74 6f 20 61 20 73 | 69 6e 67 6c 65 20 66 6f |into a s|ingle fo|
|00002650| 72 6d 75 6c 61 0d 0d 4d | 61 63 72 6f 66 6f 72 6d |rmula..M|acroform|
|00002660| 75 6c 61 3a 4e 4f 69 3a | 28 57 6f 72 6b 73 68 65 |ula:NOi:|(Workshe|
|00002670| 65 74 29 20 3d 0d 4d 41 | 43 52 4f 20 28 46 5b 63 |et) =.MA|CRO (F[c|
|00002680| 31 2e 2e 63 32 2c 72 31 | 2e 2e 72 32 5d 3b 20 6e |1..c2,r1|..r2]; n|
|00002690| 3b 20 6d 29 0d 0d 6e 20 | 3d 20 30 20 20 77 69 74 |; m)..n |= 0  wit|
|000026a0| 68 20 44 69 73 70 6c 61 | 79 3b 20 20 0d 6e 20 3d |h Displa|y;  .n =|
|000026b0| 20 31 20 20 77 69 74 68 | 6f 75 74 20 44 69 73 70 | 1  with|out Disp|
|000026c0| 6c 61 79 3b 0d 6d 20 3d | 20 30 20 6d 61 6e 75 61 |lay;.m =| 0 manua|
|000026d0| 6c 20 73 74 61 72 74 3b | 0d 6d 20 3d 20 32 20 61 |l start;|.m = 2 a|
|000026e0| 75 74 6f 6d 61 74 69 63 | 20 73 74 61 72 74 3b 0d |utomatic| start;.|
|000026f0| 46 5b 63 31 2e 2e 63 32 | 2c 72 31 2e 2e 72 32 5d |F[c1..c2|,r1..r2]|
|00002700| 20 63 6f 6e 74 61 69 6e | 73 20 74 68 65 20 0d 4d | contain|s the .M|
|00002710| 61 63 72 6f 20 66 6f 72 | 6d 75 6c 61 73 00 00 01 |acro for|mulas...|
|00002720| 0e 4d 61 63 72 6f 66 75 | 6e 63 74 69 6f 6e 20 74 |.Macrofu|nction t|
|00002730| 6f 20 63 68 6f 73 65 20 | 61 20 73 74 61 74 65 20 |o chose |a state |
|00002740| 6f 66 20 63 61 6c 63 75 | 6c 61 74 69 6f 6e 20 0d |of calcu|lation .|
|00002750| 0d 53 45 54 53 54 41 54 | 45 20 28 20 6e 20 29 0d |.SETSTAT|E ( n ).|
|00002760| 6e 0d 3d 20 31 3a 09 42 | 61 73 65 20 43 61 6c 63 |n.= 1:.B|ase Calc|
|00002770| 75 6c 61 74 69 6f 6e 0d | 3d 20 32 3a 09 50 68 61 |ulation.|= 2:.Pha|
|00002780| 73 65 20 32 0d 3d 20 33 | 3a 09 6e 6f 20 63 6f 72 |se 2.= 3|:.no cor|
|00002790| 72 65 63 74 69 6f 6e 20 | 6f 66 20 72 65 73 75 6c |rection |of resul|
|000027a0| 74 73 0d 3d 20 34 3a 09 | 63 6f 72 72 65 63 74 69 |ts.= 4:.|correcti|
|000027b0| 6f 6e 20 6f 6e 6c 79 20 | 77 69 74 68 20 62 61 73 |on only |with bas|
|000027c0| 65 20 66 6f 6d 75 6c 61 | 73 0d 3d 20 35 3a 09 63 |e fomula|s.= 5:.c|
|000027d0| 6f 72 72 65 63 74 69 6f | 6e 20 77 69 74 68 20 65 |orrectio|n with e|
|000027e0| 76 65 72 79 20 66 6f 72 | 6d 75 6c 61 0d 3d 20 36 |very for|mula.= 6|
|000027f0| 3a 09 75 70 64 61 74 65 | 20 62 75 69 6c 64 2d 75 |:.update| build-u|
|00002800| 70 20 61 72 65 61 0d 3d | 20 37 3a 09 62 75 66 66 |p area.=| 7:.buff|
|00002810| 65 72 20 65 6e 74 72 69 | 65 73 0d 3d 20 38 3a 09 |er entri|es.= 8:.|
|00002820| 65 76 61 6c 75 61 74 65 | 20 62 75 66 66 65 72 00 |evaluate| buffer.|
|00002830| 00 00 9f 4d 61 63 72 6f | 66 75 6e 63 74 69 6f 6e |...Macro|function|
|00002840| 20 74 68 61 74 20 6f 70 | 65 6e 73 20 61 20 64 69 | that op|ens a di|
|00002850| 61 6c 6f 67 2e 20 54 68 | 65 20 20 20 0d 75 73 65 |alog. Th|e   .use|
|00002860| 72 20 6d 61 79 20 71 75 | 69 74 20 74 68 65 20 6d |r may qu|it the m|
|00002870| 61 63 72 6f 20 66 72 6f | 6d 20 77 68 69 63 68 20 |acro fro|m which |
|00002880| 20 20 20 20 0d 74 68 69 | 73 20 6d 61 63 72 6f 66 |    .thi|s macrof|
|00002890| 75 6e 63 74 69 6f 6e 20 | 68 61 73 20 62 65 65 6e |unction |has been|
|000028a0| 20 63 61 6c 6c 65 64 20 | 75 70 2e 20 20 20 20 0d | called |up.    .|
|000028b0| 0d 43 4f 4e 46 49 52 4d | 20 28 22 44 6f 20 79 6f |.CONFIRM| ("Do yo|
|000028c0| 75 20 77 61 6e 74 20 74 | 6f 20 71 75 69 74 20 3f |u want t|o quit ?|
|000028d0| 22 29 00 00 00 98 4d 61 | 63 72 6f 66 75 6e 63 74 |")....Ma|crofunct|
|000028e0| 69 6f 6e 20 66 6f 72 20 | 61 75 74 6f 6d 61 74 69 |ion for |automati|
|000028f0| 63 61 6c 6c 79 20 63 72 | 65 61 74 69 6e 67 0d 61 |cally cr|eating.a|
|00002900| 73 73 69 67 6e 6d 65 6e | 74 73 20 64 75 72 69 6e |ssignmen|ts durin|
|00002910| 67 20 61 20 64 61 74 61 | 20 69 6d 70 6f 72 74 0d |g a data| import.|
|00002920| 0d 41 43 54 49 56 41 54 | 45 20 28 41 73 73 69 67 |.ACTIVAT|E (Assig|
|00002930| 6e 6d 65 6e 74 20 64 65 | 66 69 6e 69 74 69 6f 6e |nment de|finition|
|00002940| 3b 20 0d 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |; .     |        |
|00002950| 20 20 20 20 20 47 72 6f | 75 70 20 74 6f 20 62 65 |     Gro|up to be|
|00002960| 20 61 73 73 69 67 6e 65 | 64 3b 20 30 29 20 00 00 | assigne|d; 0) ..|
|00002970| 01 0a 4d 61 63 72 6f 66 | 75 6e 63 74 69 6f 6e 20 |..Macrof|unction |
|00002980| 66 6f 72 20 63 6f 70 79 | 69 6e 67 20 74 68 65 20 |for copy|ing the |
|00002990| 63 6f 6e 74 65 6e 74 73 | 0d 6f 66 20 6f 6e 65 20 |contents|.of one |
|000029a0| 73 65 6c 65 63 74 65 64 | 20 61 72 65 61 20 69 6e |selected| area in|
|000029b0| 74 6f 20 61 6e 6f 74 68 | 65 72 20 20 0d 0d 4d 41 |to anoth|er  ..MA|
|000029c0| 43 52 4f 46 55 4e 43 54 | 49 4f 4e 3a 4e 4f 69 3a |CROFUNCT|ION:NOi:|
|000029d0| 20 28 57 6f 72 6b 73 68 | 65 65 74 29 20 3d 0d 43 | (Worksh|eet) =.C|
|000029e0| 4f 50 59 20 28 46 5b 63 | 31 2e 2e 63 32 2c 72 31 |OPY (F[c|1..c2,r1|
|000029f0| 2e 2e 72 32 5d 3b 20 46 | 5b 63 33 2e 2e 63 34 2c |..r2]; F|[c3..c4,|
|00002a00| 72 33 2e 2e 72 34 5d 3b | 20 6e 29 0d 0d 6e 20 3d |r3..r4];| n)..n =|
|00002a10| 20 30 20 20 6c 69 6b 65 | 20 43 4f 50 59 20 61 6e | 0  like| COPY an|
|00002a20| 64 20 50 41 53 54 45 20 | 20 66 72 6f 6d 20 74 68 |d PASTE | from th|
|00002a30| 65 20 6d 65 6e 75 0d 6e | 20 3d 20 31 20 20 6c 69 |e menu.n| = 1  li|
|00002a40| 6b 65 20 43 4f 50 59 20 | 61 6e 64 20 50 41 53 54 |ke COPY |and PAST|
|00002a50| 45 20 53 50 45 43 49 41 | 4c 20 0d ca ca ca ca 20 |E SPECIA|L ..... |
|00002a60| 20 56 41 4c 55 45 53 20 | 4f 4e 4c 59 20 20 66 72 | VALUES |ONLY  fr|
|00002a70| 6f 6d 20 74 68 65 20 6d | 65 6e 75 0d 00 00 00 87 |om the m|enu.....|
|00002a80| 4d 61 63 72 6f 66 75 6e | 63 74 69 6f 6e 20 66 6f |Macrofun|ction fo|
|00002a90| 72 20 61 75 74 6f 6d 61 | 74 69 63 61 6c 6c 79 20 |r automa|tically |
|00002aa0| 0d 62 75 69 6c 64 69 6e | 67 20 75 70 20 61 20 63 |.buildin|g up a c|
|00002ab0| 6f 6e 6e 65 63 74 69 6f | 6e 20 74 6f 20 61 20 68 |onnectio|n to a h|
|00002ac0| 6f 73 74 0d 20 0d 43 4f | 4e 4e 45 43 54 20 28 44 |ost. .CO|NNECT (D|
|00002ad0| 61 74 61 62 61 73 65 20 | 65 78 74 65 6e 73 69 6f |atabase |extensio|
|00002ae0| 6e 3b 20 0d 20 20 20 20 | 20 20 20 20 20 20 20 20 |n; .    |        |
|00002af0| 20 20 20 20 20 20 20 48 | 6f 73 74 3b 20 41 64 64 |       H|ost; Add|
|00002b00| 69 74 69 6f 6e 20 29 00 | 00 00 50 4d 61 63 72 6f |ition ).|..PMacro|
|00002b10| 66 75 6e 63 74 69 6f 6e | 20 74 68 61 74 20 73 65 |function| that se|
|00002b20| 6e 64 73 0d 61 20 71 75 | 65 72 79 20 74 6f 20 61 |nds.a qu|ery to a|
|00002b30| 20 68 6f 73 74 20 20 20 | 20 20 20 20 20 20 20 20 | host   |        |
|00002b40| 20 20 0d 0d 53 45 4e 44 | 20 28 51 75 65 72 79 3b |  ..SEND| (Query;|
|00002b50| 20 46 69 6c 65 20 6e 61 | 6d 65 29 00 00 00 32 4d | File na|me)...2M|
|00002b60| 61 63 72 6f 66 75 6e 63 | 74 69 6f 6e 20 66 6f 72 |acrofunc|tion for|
|00002b70| 20 0d 71 75 69 74 74 69 | 6e 67 20 6d 61 63 43 6f | .quitti|ng macCo|
|00002b80| 6e 74 72 6f 6c 0d 0d 51 | 55 49 54 20 28 20 30 20 |ntrol..Q|UIT ( 0 |
|00002b90| 29 00 00 00 65 4d 61 63 | 72 6f 66 75 6e 63 74 69 |)...eMac|rofuncti|
|00002ba0| 6f 6e 20 66 6f 72 20 6f | 70 65 6e 69 6e 67 0d 61 |on for o|pening.a|
|00002bb0| 20 77 6f 72 6b 73 68 65 | 65 74 0d 0d 4d 41 43 52 | workshe|et..MACR|
|00002bc0| 4f 46 55 4e 43 54 49 4f | 4e 20 3a 20 4e 4f 69 20 |OFUNCTIO|N : NOi |
|00002bd0| 3d 0d 4f 50 45 4e 20 28 | 41 54 54 52 49 42 55 54 |=.OPEN (|ATTRIBUT|
|00002be0| 45 0d 20 28 4e 61 6d 65 | 20 6f 66 20 77 6f 72 6b |E. (Name| of work|
|00002bf0| 73 68 65 65 74 29 3b 20 | 30 29 00 00 00 f8 4d 61 |sheet); |0)....Ma|
|00002c00| 63 72 6f 66 75 6e 63 74 | 69 6f 6e 20 61 6e 61 6c |crofunct|ion anal|
|00002c10| 79 73 69 6e 67 20 61 6c | 20 6c 20 66 6f 72 6d 75 |ysing al| l formu|
|00002c20| 6c 61 73 0d 0d 41 4e 41 | 4c 59 53 45 20 28 20 6e |las..ANA|LYSE ( n|
|00002c30| 20 29 0d 0d 28 20 6e 20 | 3d 20 31 20 3a 20 73 77 | )..( n |= 1 : sw|
|00002c40| 69 74 63 68 20 74 6f 20 | 61 6e 61 6c 79 73 69 73 |itch to |analysis|
|00002c50| 20 6d 6f 64 65 3b 0d 20 | 20 6e 20 3d 20 30 20 3a | mode;. | n = 0 :|
|00002c60| 20 73 77 69 74 63 68 20 | 74 6f 20 6e 6f 72 6d 61 | switch |to norma|
|00002c70| 6c 20 6d 6f 64 65 20 20 | 29 0d 0d 46 6f 72 20 61 |l mode  |)..For a|
|00002c80| 6e 20 61 6e 61 6c 79 73 | 69 73 20 61 20 72 65 63 |n analys|is a rec|
|00002c90| 61 6c 63 75 6c 61 74 69 | 6f 6e 20 68 61 73 20 74 |alculati|on has t|
|00002ca0| 6f 20 74 61 6b 65 20 70 | 6c 61 63 65 2e 0d 50 72 |o take p|lace..Pr|
|00002cb0| 65 76 69 6f 75 73 6c 79 | 20 63 61 6c 63 75 6c 61 |eviously| calcula|
|00002cc0| 74 65 64 20 72 65 73 75 | 6c 74 73 20 77 69 6c 6c |ted resu|lts will|
|00002cd0| 20 62 65 20 6f 76 65 72 | 77 72 69 74 74 65 6e 0d | be over|written.|
|00002ce0| 64 75 72 69 6e 67 20 74 | 68 69 73 20 70 72 6f 63 |during t|his proc|
|00002cf0| 65 64 75 72 65 2e 00 00 | 00 5b 54 68 69 73 20 65 |edure...|.[This e|
|00002d00| 6e 61 62 6c 65 73 20 74 | 68 65 20 75 73 65 72 20 |nables t|he user |
|00002d10| 20 20 20 20 20 20 20 20 | 0d 74 6f 20 63 68 6f 6f |        |.to choo|
|00002d20| 73 65 20 61 64 64 69 74 | 69 6f 6e 61 6c 20 20 20 |se addit|ional   |
|00002d30| 20 20 20 20 20 20 20 20 | 0d 66 75 6e 63 74 69 6f |        |.functio|
|00002d40| 6e 73 20 74 68 61 74 20 | 61 72 65 20 61 76 61 69 |ns that |are avai|
|00002d50| 6c 61 62 6c 65 00 00 00 | a9 45 6e 61 62 6c 65 73 |lable...|.Enables|
|00002d60| 20 74 68 65 20 75 73 65 | 72 20 74 6f 20 64 65 66 | the use|r to def|
|00002d70| 69 6e 65 20 61 6e 64 20 | 0d 72 65 63 61 6c 6c 20 |ine and |.recall |
|00002d80| 61 6e 20 61 73 73 69 67 | 6e 6d 65 6e 74 20 0d 0d |an assig|nment ..|
|00002d90| 41 53 53 49 47 4e 4d 45 | 4e 54 3a 4e 4f 31 3a 0d |ASSIGNME|NT:NO1:.|
|00002da0| 44 61 69 72 79 20 50 72 | 6f 64 75 63 74 73 20 3d |Dairy Pr|oducts =|
|00002db0| 20 42 75 74 74 65 72 20 | 0d 6f 72 0d 0d 53 61 6c | Butter |.or..Sal|
|00002dc0| 65 73 3a a5 50 72 6f 64 | 75 63 74 20 47 72 6f 75 |es:.Prod|uct Grou|
|00002dd0| 70 20 3d 20 0d 53 55 4d | 20 28 a5 50 72 6f 64 75 |p = .SUM| (.Produ|
|00002de0| 63 74 73 3a 28 41 53 53 | 49 47 4e 4d 45 4e 54 3a |cts:(ASS|IGNMENT:|
|00002df0| 0d a5 50 72 6f 64 75 63 | 74 20 47 72 6f 75 70 29 |..Produc|t Group)|
|00002e00| 29 0d 00 00 00 4c 55 73 | 65 64 20 74 6f 20 64 65 |)....LUs|ed to de|
|00002e10| 66 69 6e 65 20 0d 61 20 | 6d 61 63 72 6f 66 6f 72 |fine .a |macrofor|
|00002e20| 6d 75 6c 61 0d 0d 4d 41 | 43 52 4f 46 55 4e 43 54 |mula..MA|CROFUNCT|
|00002e30| 49 4f 4e 3a 20 4e 4f 69 | 20 20 3d 0d 41 55 54 4f |ION: NOi|  =.AUTO|
|00002e40| 41 53 53 49 47 4e 4d 45 | 4e 54 20 28 20 2e 2e 2e |ASSIGNME|NT ( ...|
|00002e50| 20 29 00 00 00 7f 46 6f | 72 20 6e 75 6d 62 65 72 | )....Fo|r number|
|00002e60| 69 6e 67 20 61 73 73 69 | 67 6e 6d 65 6e 74 73 0d |ing assi|gnments.|
|00002e70| 6f 72 20 6d 61 63 72 6f | 66 6f 72 6d 75 6c 61 73 |or macro|formulas|
|00002e80| 0d 0d 41 53 53 49 47 4e | 4d 45 4e 54 20 3a 20 4e |..ASSIGN|MENT : N|
|00002e90| 4f 31 3a 20 53 74 6f 72 | 65 20 31 20 3d 0d 50 72 |O1: Stor|e 1 =.Pr|
|00002ea0| 6f 64 75 63 74 20 31 0d | 6f 72 0d 41 53 53 49 47 |oduct 1.|or.ASSIG|
|00002eb0| 4e 4d 45 4e 54 20 3a 20 | 4e 4f 31 20 20 3d 0d 41 |NMENT : |NO1  =.A|
|00002ec0| 55 54 4f 41 53 53 49 47 | 4e 4d 45 4e 54 20 28 20 |UTOASSIG|NMENT ( |
|00002ed0| 2e 2e 2e 20 29 00 00 00 | 80 46 6f 72 20 6e 75 6d |... )...|.For num|
|00002ee0| 62 65 72 69 6e 67 20 61 | 73 73 69 67 6e 6d 65 6e |bering a|ssignmen|
|00002ef0| 74 73 0d 6f 72 20 6d 61 | 63 72 6f 66 6f 72 6d 75 |ts.or ma|croformu|
|00002f00| 6c 61 73 0d 0d 41 53 53 | 49 47 4e 4d 45 4e 54 20 |las..ASS|IGNMENT |
|00002f10| 3a 20 4e 52 34 3a 20 53 | 74 6f 72 65 20 31 20 3d |: NR4: S|tore 1 =|
|00002f20| 0d 50 72 6f 64 75 63 74 | 20 31 0d 6f 72 0d 4d 41 |.Product| 1.or.MA|
|00002f30| 43 52 4f 46 4f 52 4d 55 | 4c 41 20 3a 20 4e 52 37 |CROFORMU|LA : NR7|
|00002f40| 20 3d 0d 41 55 54 4f 41 | 53 53 49 47 4e 4d 45 4e | =.AUTOA|SSIGNMEN|
|00002f50| 54 28 20 2e 2e 2e 20 29 | 20 00 00 00 6d 43 68 61 |T( ... )| ...mCha|
|00002f60| 6e 67 65 73 20 61 6e 79 | 20 74 69 6d 65 20 72 65 |nges any| time re|
|00002f70| 66 65 72 65 6e 63 65 20 | 0d 69 6e 74 6f 20 61 20 |ference |.into a |
|00002f80| 79 65 61 72 6c 79 20 74 | 69 6d 65 20 72 65 66 65 |yearly t|ime refe|
|00002f90| 72 65 6e 63 65 0d 0d 59 | 45 41 52 20 28 20 44 61 |rence..Y|EAR ( Da|
|00002fa0| 74 65 20 29 0d 0d 28 66 | 6f 72 20 65 78 61 6d 70 |te )..(f|or examp|
|00002fb0| 6c 65 2c 20 31 2f 31 33 | 2f 39 31 20 0d 62 65 63 |le, 1/13|/91 .bec|
|00002fc0| 6f 6d 65 73 20 31 39 39 | 31 29 00 00 00 19 6c 6f |omes 199|1)....lo|
|00002fd0| 67 20 62 61 73 65 20 31 | 30 0d 0d 4c 47 20 28 20 |g base 1|0..LG ( |
|00002fe0| 56 61 6c 75 65 20 29 00 | 00 00 1d 41 62 73 6f 6c |Value ).|...Absol|
|00002ff0| 75 74 65 20 76 61 6c 75 | 65 0d 0d 41 42 53 20 28 |ute valu|e..ABS (|
|00003000| 20 56 61 6c 75 65 20 29 | 00 00 01 29 4d 61 63 72 | Value )|...)Macr|
|00003010| 6f 66 75 6e 63 74 69 6f | 6e 20 66 6f 72 20 74 68 |ofunctio|n for th|
|00003020| 65 20 6c 69 73 74 69 6e | 67 20 0d 6f 66 20 76 61 |e listin|g .of va|
|00003030| 72 69 6f 75 73 20 61 73 | 73 69 67 6e 6d 65 6e 74 |rious as|signment|
|00003040| 73 20 0d 73 70 61 6e 6e | 69 6e 67 20 6d 75 6c 74 |s .spann|ing mult|
|00003050| 69 70 6c 65 20 6c 65 76 | 65 6c 73 20 0d 28 6d 75 |iple lev|els .(mu|
|00003060| 73 74 20 62 65 20 64 65 | 66 69 6e 65 64 20 69 6e |st be de|fined in|
|00003070| 20 61 20 66 6c 65 78 69 | 62 6c 65 20 63 65 6c 6c | a flexi|ble cell|
|00003080| 29 0d 0d 45 58 50 41 4e | 44 20 28 46 5b 63 31 2e |)..EXPAN|D (F[c1.|
|00003090| 2e 63 32 2c 72 31 2e 2e | 72 32 5d 3b 20 61 3b 20 |.c2,r1..|r2]; a; |
|000030a0| 30 3b 20 62 29 0d 20 0d | 61 20 3d 20 50 61 67 65 |0; b). .|a = Page|
|000030b0| 20 6e 75 6d 62 65 72 3b | 0d 62 20 3d 20 30 20 52 | number;|.b = 0 R|
|000030c0| 65 70 65 74 69 74 69 6f | 6e 20 6f 66 20 61 74 74 |epetitio|n of att|
|000030d0| 72 69 62 75 74 65 73 3b | 0d 62 20 3d 20 31 20 4e |ributes;|.b = 1 N|
|000030e0| 6f 20 72 65 70 65 74 69 | 74 69 6f 6e 20 6f 66 20 |o repeti|tion of |
|000030f0| 61 74 74 72 69 62 75 74 | 65 73 3b 0d 46 5b 63 31 |attribut|es;.F[c1|
|00003100| 2e 2e 63 32 2c 72 31 2e | 2e 72 32 5d 20 64 65 66 |..c2,r1.|.r2] def|
|00003110| 69 6e 65 73 20 72 61 6e | 67 65 20 0d 77 68 65 72 |ines ran|ge .wher|
|00003120| 65 20 6f 75 74 70 75 74 | 20 69 73 20 64 69 73 70 |e output| is disp|
|00003130| 6c 61 79 65 64 00 00 00 | 19 4e 61 74 75 72 61 6c |layed...|.Natural|
|00003140| 20 6c 6f 67 0d 0d 4c 4e | 20 28 20 56 61 6c 75 65 | log..LN| ( Value|
|00003150| 20 29 00 00 00 1b 53 71 | 75 61 72 65 20 72 6f 6f | )....Sq|uare roo|
|00003160| 74 0d 0d 53 51 52 54 20 | 28 20 56 61 6c 75 65 20 |t..SQRT |( Value |
|00003170| 29 00 00 00 1f 49 6e 74 | 65 67 65 72 20 66 75 6e |)....Int|eger fun|
|00003180| 63 74 69 6f 6e 0d 0d 49 | 4e 54 20 28 20 56 61 6c |ction..I|NT ( Val|
|00003190| 75 65 20 29 00 00 00 1e | 53 71 75 61 72 65 20 66 |ue )....|Square f|
|000031a0| 75 6e 63 74 69 6f 6e 0d | 0d 53 51 52 20 28 20 56 |unction.|.SQR ( V|
|000031b0| 61 6c 75 65 20 29 00 00 | 00 32 53 69 6e 65 20 66 |alue )..|.2Sine f|
|000031c0| 75 6e 63 74 69 6f 6e 0d | 0d 53 49 4e 20 28 20 41 |unction.|.SIN ( A|
|000031d0| 6e 67 6c 65 20 29 0d 0d | 28 20 41 6e 67 6c 65 20 |ngle )..|( Angle |
|000031e0| 69 6e 20 64 65 67 72 65 | 65 73 20 29 00 00 00 33 |in degre|es )...3|
|000031f0| 43 6f 73 69 6e 65 20 66 | 75 6e 63 74 69 6f 6e 0d |Cosine f|unction.|
|00003200| 0d 43 4f 53 20 28 20 41 | 6e 67 6c 65 20 29 0d 0d |.COS ( A|ngle )..|
|00003210| 28 41 6e 67 6c 65 20 69 | 6e 20 64 65 67 72 65 65 |(Angle i|n degree|
|00003220| 73 20 29 00 00 00 34 54 | 61 6e 67 65 6e 74 20 66 |s )...4T|angent f|
|00003230| 75 6e 63 74 69 6f 6e 0d | 0d 54 41 4e 20 28 20 41 |unction.|.TAN ( A|
|00003240| 6e 67 6c 65 20 29 0d 0d | 28 41 6e 67 6c 65 20 69 |ngle )..|(Angle i|
|00003250| 6e 20 64 65 67 72 65 65 | 73 20 29 00 00 00 39 41 |n degree|s )...9A|
|00003260| 72 63 73 69 6e 65 20 66 | 75 6e 63 74 69 6f 6e 0d |rcsine f|unction.|
|00003270| 0d 41 52 43 53 49 4e 20 | 28 20 56 61 6c 75 65 20 |.ARCSIN |( Value |
|00003280| 29 0d 0d 28 20 52 65 73 | 75 6c 74 20 69 6e 20 64 |)..( Res|ult in d|
|00003290| 65 67 72 65 65 73 20 29 | 00 00 00 3b 41 72 63 63 |egrees )|...;Arcc|
|000032a0| 6f 73 69 6e 65 20 66 75 | 6e 63 74 69 6f 6e 0d 0d |osine fu|nction..|
|000032b0| 41 52 43 43 4f 53 20 28 | 20 56 61 6c 75 65 20 29 |ARCCOS (| Value )|
|000032c0| 0d 0d 28 20 52 65 73 75 | 6c 74 20 69 6e 20 64 65 |..( Resu|lt in de|
|000032d0| 67 72 65 65 73 20 29 00 | 00 00 3c 41 72 63 74 61 |grees ).|..<Arcta|
|000032e0| 6e 67 65 6e 74 20 66 75 | 6e 63 74 69 6f 6e 0d 0d |ngent fu|nction..|
|000032f0| 41 52 43 54 41 4e 20 28 | 20 56 61 6c 75 65 20 29 |ARCTAN (| Value )|
|00003300| 0d 0d 28 20 52 65 73 75 | 6c 74 20 69 6e 20 64 65 |..( Resu|lt in de|
|00003310| 67 72 65 65 73 20 29 00 | 00 00 bb 4d 65 61 6e 20 |grees ).|...Mean |
|00003320| 76 61 6c 75 65 20 66 75 | 6e 63 74 69 6f 6e 0d 0d |value fu|nction..|
|00003330| 4d 45 41 4e 20 28 20 46 | 5b 31 2e 2e 31 30 2c 34 |MEAN ( F|[1..10,4|
|00003340| 5d 20 29 0d 0d 6f 72 0d | 53 61 6c 65 73 3a 31 2f |] )..or.|Sales:1/|
|00003350| 39 30 20 3d 20 4d 45 41 | 4e 20 28 20 a5 50 72 6f |90 = MEA|N ( .Pro|
|00003360| 64 75 63 74 73 0d 3a 28 | 61 6c 6c 29 3a 53 61 6c |ducts.:(|all):Sal|
|00003370| 65 73 3a 31 2f 39 30 20 | 29 0d 0d 6f 72 0d 53 61 |es:1/90 |)..or.Sa|
|00003380| 6c 65 73 3a a5 50 72 6f | 64 75 63 74 20 67 72 6f |les:.Pro|duct gro|
|00003390| 75 70 73 3a 31 2f 39 30 | 20 3d 0d 4d 45 41 4e 20 |ups:1/90| =.MEAN |
|000033a0| 28 20 a5 50 72 6f 64 75 | 63 74 73 3a 28 41 73 73 |( .Produ|cts:(Ass|
|000033b0| 69 67 6e 6d 65 6e 74 0d | 3a a5 50 72 6f 64 75 63 |ignment.|:.Produc|
|000033c0| 74 20 67 72 6f 75 70 73 | 29 3a 53 61 6c 65 73 3a |t groups|):Sales:|
|000033d0| 31 2f 39 30 20 29 00 00 | 00 65 4c 6f 67 69 63 61 |1/90 )..|.eLogica|
|000033e0| 6c 20 22 41 4e 44 22 20 | 63 61 6c 63 75 6c 61 74 |l "AND" |calculat|
|000033f0| 69 6f 6e 73 0d 0d 49 46 | 20 20 20 28 20 28 20 53 |ions..IF|   ( ( S|
|00003400| 61 6c 65 73 20 3e 20 31 | 30 30 30 20 29 20 0d 41 |ales > 1|000 ) .A|
|00003410| 4e 44 20 28 20 50 72 6f | 66 69 74 20 3d 20 35 30 |ND ( Pro|fit = 50|
|00003420| 30 20 29 20 29 0d 54 48 | 45 4e 20 28 20 2e 2e 2e |0 ) ).TH|EN ( ...|
|00003430| 20 29 20 45 4c 53 45 20 | 28 20 2e 2e 2e 20 29 00 | ) ELSE |( ... ).|
|00003440| 00 00 7d 43 68 61 6e 67 | 65 73 20 61 6e 79 20 74 |..}Chang|es any t|
|00003450| 69 6d 65 20 72 65 66 65 | 72 65 6e 63 65 20 0d 69 |ime refe|rence .i|
|00003460| 6e 74 6f 20 61 20 77 65 | 65 6b 6c 79 20 28 37 20 |nto a we|ekly (7 |
|00003470| 64 61 79 29 0d 20 74 69 | 6d 65 20 72 65 66 65 72 |day). ti|me refer|
|00003480| 65 6e 63 65 0d 0d 4e 44 | 41 59 20 28 20 44 61 74 |ence..ND|AY ( Dat|
|00003490| 65 20 29 0d 0d 28 66 6f | 72 20 65 78 61 6d 70 6c |e )..(fo|r exampl|
|000034a0| 65 2c 20 31 39 39 31 20 | 6f 72 0d 31 2f 39 31 20 |e, 1991 |or.1/91 |
|000034b0| 62 65 63 6f 6d 65 73 20 | 31 2f 31 2f 39 31 20 29 |becomes |1/1/91 )|
|000034c0| 00 00 00 60 4c 6f 67 69 | 63 61 6c 20 22 4f 52 22 |...`Logi|cal "OR"|
|000034d0| 20 63 61 6c 63 75 6c 61 | 74 69 6f 6e 73 0d 0d 49 | calcula|tions..I|
|000034e0| 46 20 28 20 28 20 53 61 | 6c 65 73 20 3e 20 31 30 |F ( ( Sa|les > 10|
|000034f0| 30 30 20 29 0d 4f 52 20 | 28 20 50 72 6f 66 69 74 |00 ).OR |( Profit|
|00003500| 20 3d 20 35 30 30 20 29 | 20 29 0d 54 48 45 4e 20 | = 500 )| ).THEN |
|00003510| 28 20 2e 2e 2e 20 29 20 | 45 4c 53 45 20 28 20 2e |( ... ) |ELSE ( .|
|00003520| 2e 2e 20 29 00 00 00 76 | 43 68 61 6e 67 65 73 20 |.. )...v|Changes |
|00003530| 61 6e 79 20 74 69 6d 65 | 20 72 65 66 65 72 65 6e |any time| referen|
|00003540| 63 65 20 0d 69 6e 74 6f | 20 61 20 77 65 65 6b 6c |ce .into| a weekl|
|00003550| 79 20 28 35 20 64 61 79 | 29 0d 20 74 69 6d 65 20 |y (5 day|). time |
|00003560| 72 65 66 65 72 65 6e 63 | 65 0d 0d 46 44 41 59 20 |referenc|e..FDAY |
|00003570| 28 20 44 61 74 65 20 29 | 0d 0d 28 66 6f 72 20 65 |( Date )|..(for e|
|00003580| 78 61 6d 70 6c 65 2c 20 | 36 2f 39 31 20 0d 62 65 |xample, |6/91 .be|
|00003590| 63 6f 6d 65 73 20 36 2f | 33 2f 39 31 20 29 00 00 |comes 6/|3/91 )..|
|000035a0| 00 76 43 68 61 6e 67 65 | 73 20 61 6e 79 20 74 69 |.vChange|s any ti|
|000035b0| 6d 65 20 72 65 66 65 72 | 65 6e 63 65 20 0d 69 6e |me refer|ence .in|
|000035c0| 74 6f 20 61 20 77 65 65 | 6b 6c 79 20 28 36 20 64 |to a wee|kly (6 d|
|000035d0| 61 79 29 0d 20 74 69 6d | 65 20 72 65 66 65 72 65 |ay). tim|e refere|
|000035e0| 6e 63 65 0d 0d 53 44 41 | 59 20 28 20 44 61 74 65 |nce..SDA|Y ( Date|
|000035f0| 20 29 0d 0d 28 66 6f 72 | 20 65 78 61 6d 70 6c 65 | )..(for| example|
|00003600| 2c 20 39 2f 39 31 20 0d | 62 65 63 6f 6d 65 73 20 |, 9/91 .|becomes |
|00003610| 39 2f 32 2f 39 31 20 29 | 00 00 00 7a 43 68 61 6e |9/2/91 )|...zChan|
|00003620| 67 65 73 20 61 6e 79 20 | 74 69 6d 65 20 72 65 66 |ges any |time ref|
|00003630| 65 72 65 6e 63 65 20 0d | 69 6e 74 6f 20 61 20 71 |erence .|into a q|
|00003640| 75 61 72 74 65 72 6c 79 | 20 74 69 6d 65 0d 72 65 |uarterly| time.re|
|00003650| 66 65 72 65 6e 63 65 0d | 0d 51 55 41 52 54 45 52 |ference.|.QUARTER|
|00003660| 20 28 20 44 61 74 65 20 | 29 0d 0d 28 66 6f 72 20 | ( Date |)..(for |
|00003670| 65 78 61 6d 70 6c 65 2c | 20 31 39 39 31 20 6f 72 |example,| 1991 or|
|00003680| 20 32 2f 31 2f 39 31 0d | 62 65 63 6f 6d 65 73 20 | 2/1/91.|becomes |
|00003690| 51 31 2d 39 31 29 00 00 | 00 7b 43 68 61 6e 67 65 |Q1-91)..|.{Change|
|000036a0| 73 20 61 6e 79 20 74 69 | 6d 65 20 72 65 66 65 72 |s any ti|me refer|
|000036b0| 65 6e 63 65 20 0d 69 6e | 74 6f 20 61 20 68 61 6c |ence .in|to a hal|
|000036c0| 66 2d 79 65 61 72 20 74 | 69 6d 65 0d 72 65 66 65 |f-year t|ime.refe|
|000036d0| 72 65 6e 63 65 0d 0d 48 | 41 4c 46 59 45 41 52 20 |rence..H|ALFYEAR |
|000036e0| 28 20 44 61 74 65 20 29 | 0d 0d 28 66 6f 72 20 65 |( Date )|..(for e|
|000036f0| 78 61 6d 70 6c 65 2c 20 | 31 39 39 31 20 6f 72 20 |xample, |1991 or |
|00003700| 35 2f 31 2f 39 31 0d 62 | 65 63 6f 6d 65 73 20 48 |5/1/91.b|ecomes H|
|00003710| 31 2d 39 31 29 00 00 00 | 85 43 68 61 6e 67 65 73 |1-91)...|.Changes|
|00003720| 20 61 6e 79 20 74 69 6d | 65 20 72 65 66 65 72 65 | any tim|e refere|
|00003730| 6e 63 65 20 0d 69 6e 74 | 6f 20 69 74 73 20 63 6f |nce .int|o its co|
|00003740| 72 72 65 73 70 6f 6e 64 | 69 6e 67 0d 20 77 65 65 |rrespond|ing. wee|
|00003750| 6b 6c 79 20 74 69 6d 65 | 20 72 65 66 65 72 65 6e |kly time| referen|
|00003760| 63 65 0d 0d 57 45 45 4b | 20 28 20 44 61 74 65 20 |ce..WEEK| ( Date |
|00003770| 29 0d 0d 28 66 6f 72 20 | 65 78 61 6d 70 6c 65 2c |)..(for |example,|
|00003780| 20 31 39 39 31 20 6f 72 | 20 31 2f 35 2f 39 31 0d | 1991 or| 1/5/91.|
|00003790| 62 65 63 6f 6d 65 73 20 | 57 31 2d 39 31 29 00 00 |becomes |W1-91)..|
|000037a0| 00 bc 54 68 69 73 20 66 | 75 6e 63 74 69 6f 6e 20 |..This f|unction |
|000037b0| 64 65 74 65 72 6d 69 6e | 65 73 20 74 68 65 20 6e |determin|es the n|
|000037c0| 75 6d 62 65 72 0d 6f 66 | 20 66 69 65 6c 64 73 20 |umber.of| fields |
|000037d0| 77 68 69 63 68 20 61 72 | 65 20 69 6e 20 61 20 67 |which ar|e in a g|
|000037e0| 69 76 65 6e 20 72 61 6e | 67 65 2c 0d 6f 72 20 74 |iven ran|ge,.or t|
|000037f0| 68 65 20 6e 75 6d 62 65 | 72 20 6f 66 20 61 74 74 |he numbe|r of att|
|00003800| 72 69 62 75 74 65 73 20 | 69 6e 20 61 0d 67 69 76 |ributes |in a.giv|
|00003810| 65 6e 20 64 61 74 61 62 | 61 73 65 20 73 65 6c 65 |en datab|ase sele|
|00003820| 63 74 69 6f 6e 0d 0d 43 | 4f 55 4e 54 41 4c 4c 28 |ction..C|OUNTALL(|
|00003830| 20 46 5b 63 2c 72 31 2e | 2e 72 32 5d 20 29 0d 0d | F[c,r1.|.r2] )..|
|00003840| 6f 72 0d 43 4f 55 4e 54 | 41 4c 4c 28 20 a5 50 72 |or.COUNT|ALL( .Pr|
|00003850| 6f 64 75 63 74 73 3a 28 | 61 6c 6c 29 20 29 00 00 |oducts:(|all) )..|
|00003860| 00 3b 43 6f 72 72 65 73 | 70 6f 6e 64 69 6e 67 20 |.;Corres|ponding |
|00003870| 77 65 65 6b 64 61 79 0d | 66 6f 72 20 61 20 67 69 |weekday.|for a gi|
|00003880| 76 65 6e 20 64 61 74 65 | 0d 0d 0d 44 41 59 4f 46 |ven date|...DAYOF|
|00003890| 57 45 45 4b 20 28 20 44 | 61 74 65 20 29 00 00 00 |WEEK ( D|ate )...|
|000038a0| 81 4e 75 6d 62 65 72 20 | 6f 66 20 22 49 6e 74 65 |.Number |of "Inte|
|000038b0| 72 65 73 74 20 44 61 79 | 73 22 20 ca ca ca ca ca |rest Day|s" .....|
|000038c0| 0d 62 65 74 77 65 65 6e | 20 74 77 6f 20 64 61 74 |.between| two dat|
|000038d0| 65 73 0d 0d 4e 75 6d 62 | 65 72 20 6f 66 20 69 6e |es..Numb|er of in|
|000038e0| 74 65 72 65 73 74 20 64 | 61 79 73 20 3d 20 0d 58 |terest d|ays = .X|
|000038f0| 49 4e 54 45 52 45 53 54 | 44 41 59 53 20 28 20 44 |INTEREST|DAYS ( D|
|00003900| 61 74 65 20 31 20 29 20 | 2d 0d 58 49 4e 54 45 52 |ate 1 ) |-.XINTER|
|00003910| 45 53 54 44 41 59 53 20 | 28 20 44 61 74 65 20 32 |ESTDAYS |( Date 2|
|00003920| 20 29 00 00 00 d8 4d 69 | 6e 69 6d 75 6d 20 76 61 | )....Mi|nimum va|
|00003930| 6c 75 65 20 66 72 6f 6d | 20 61 20 0d 73 65 6c 65 |lue from| a .sele|
|00003940| 63 74 69 6f 6e 20 6f 66 | 20 76 61 6c 75 65 73 0d |ction of| values.|
|00003950| 0d 4d 49 4e 49 4d 55 4d | 20 28 20 46 5b 31 2e 2e |.MINIMUM| ( F[1..|
|00003960| 31 30 2c 34 5d 20 29 0d | 0d 6f 72 0d 53 61 6c 65 |10,4] ).|.or.Sale|
|00003970| 73 3a 31 2f 39 30 20 3d | 20 4d 49 4e 49 4d 55 4d |s:1/90 =| MINIMUM|
|00003980| 20 0d 28 a5 50 72 6f 64 | 75 63 74 73 3a 28 61 6c | .(.Prod|ucts:(al|
|00003990| 6c 29 3a 53 61 6c 65 73 | 3a 31 2f 39 30 20 29 0d |l):Sales|:1/90 ).|
|000039a0| 0d 6f 72 0d 53 61 6c 65 | 73 3a a5 50 72 6f 64 75 |.or.Sale|s:.Produ|
|000039b0| 63 74 20 67 72 6f 75 70 | 73 3a 31 2f 39 30 20 3d |ct group|s:1/90 =|
|000039c0| 0d 4d 49 4e 49 4d 55 4d | 20 28 a5 50 72 6f 64 75 |.MINIMUM| (.Produ|
|000039d0| 63 74 73 3a 28 41 73 73 | 69 67 6e 6d 65 6e 74 0d |cts:(Ass|ignment.|
|000039e0| 3a a5 50 72 6f 64 75 63 | 74 20 67 72 6f 75 70 73 |:.Produc|t groups|
|000039f0| 29 3a 53 61 6c 65 73 3a | 31 2f 39 30 20 29 00 00 |):Sales:|1/90 )..|
|00003a00| 00 d8 4d 61 78 69 6d 75 | 6d 20 76 61 6c 75 65 20 |..Maximu|m value |
|00003a10| 66 72 6f 6d 20 61 20 0d | 73 65 6c 65 63 74 69 6f |from a .|selectio|
|00003a20| 6e 20 6f 66 20 76 61 6c | 75 65 73 0d 0d 4d 41 58 |n of val|ues..MAX|
|00003a30| 49 4d 55 4d 20 28 20 46 | 5b 31 2e 2e 31 30 2c 34 |IMUM ( F|[1..10,4|
|00003a40| 5d 20 29 0d 0d 6f 72 0d | 53 61 6c 65 73 3a 31 2f |] )..or.|Sales:1/|
|00003a50| 39 30 20 3d 20 4d 41 58 | 49 4d 55 4d 20 0d 28 a5 |90 = MAX|IMUM .(.|
|00003a60| 50 72 6f 64 75 63 74 73 | 3a 28 61 6c 6c 29 3a 53 |Products|:(all):S|
|00003a70| 61 6c 65 73 3a 31 2f 39 | 30 20 29 0d 0d 6f 72 0d |ales:1/9|0 )..or.|
|00003a80| 53 61 6c 65 73 3a a5 50 | 72 6f 64 75 63 74 20 67 |Sales:.P|roduct g|
|00003a90| 72 6f 75 70 73 3a 31 2f | 39 30 20 3d 0d 4d 41 58 |roups:1/|90 =.MAX|
|00003aa0| 49 4d 55 4d 20 28 a5 50 | 72 6f 64 75 63 74 73 3a |IMUM (.P|roducts:|
|00003ab0| 28 41 73 73 69 67 6e 6d | 65 6e 74 0d 3a a5 50 72 |(Assignm|ent.:.Pr|
|00003ac0| 6f 64 75 63 74 20 67 72 | 6f 75 70 73 29 3a 53 61 |oduct gr|oups):Sa|
|00003ad0| 6c 65 73 3a 31 2f 39 30 | 20 29 00 00 00 d1 46 75 |les:1/90| )....Fu|
|00003ae0| 6e 63 74 69 6f 6e 20 66 | 6f 72 20 73 75 6d 6d 69 |nction f|or summi|
|00003af0| 6e 67 20 75 70 0d 61 6c | 6c 20 70 6f 73 69 74 69 |ng up.al|l positi|
|00003b00| 76 65 20 76 61 6c 75 65 | 73 0d 0d 50 53 55 4d 20 |ve value|s..PSUM |
|00003b10| 28 20 46 5b 31 2e 2e 31 | 30 2c 34 5d 20 29 0d 0d |( F[1..1|0,4] )..|
|00003b20| 6f 72 0d 53 61 6c 65 73 | 3a 31 2f 39 30 20 3d 20 |or.Sales|:1/90 = |
|00003b30| 50 53 55 4d 28 20 a5 50 | 72 6f 64 75 63 74 73 0d |PSUM( .P|roducts.|
|00003b40| 3a 28 61 6c 6c 29 3a 53 | 61 6c 65 73 3a 31 2f 39 |:(all):S|ales:1/9|
|00003b50| 30 20 29 0d 0d 6f 72 0d | 53 61 6c 65 73 3a a5 50 |0 )..or.|Sales:.P|
|00003b60| 72 6f 64 75 63 74 20 67 | 72 6f 75 70 73 3a 31 2f |roduct g|roups:1/|
|00003b70| 39 30 20 3d 0d 50 53 55 | 4d 28 20 a5 50 72 6f 64 |90 =.PSU|M( .Prod|
|00003b80| 75 63 74 73 3a 28 41 73 | 73 69 67 6e 6d 65 6e 74 |ucts:(As|signment|
|00003b90| 0d 3a a5 50 72 6f 64 75 | 63 74 20 67 72 6f 75 70 |.:.Produ|ct group|
|00003ba0| 73 29 3a 53 61 6c 65 73 | 3a 31 2f 39 30 20 29 00 |s):Sales|:1/90 ).|
|00003bb0| 00 00 d1 46 75 6e 63 74 | 69 6f 6e 20 66 6f 72 20 |...Funct|ion for |
|00003bc0| 73 75 6d 6d 69 6e 67 20 | 75 70 0d 61 6c 6c 20 6e |summing |up.all n|
|00003bd0| 65 67 61 74 69 76 65 20 | 76 61 6c 75 65 73 0d 0d |egative |values..|
|00003be0| 4e 53 55 4d 20 28 20 46 | 5b 31 2e 2e 31 30 2c 34 |NSUM ( F|[1..10,4|
|00003bf0| 5d 20 29 0d 0d 6f 72 0d | 53 61 6c 65 73 3a 31 2f |] )..or.|Sales:1/|
|00003c00| 39 30 20 3d 20 4e 53 55 | 4d 28 20 a5 50 72 6f 64 |90 = NSU|M( .Prod|
|00003c10| 75 63 74 73 0d 3a 28 61 | 6c 6c 29 3a 53 61 6c 65 |ucts.:(a|ll):Sale|
|00003c20| 73 3a 31 2f 39 30 20 29 | 0d 0d 6f 72 0d 53 61 6c |s:1/90 )|..or.Sal|
|00003c30| 65 73 3a a5 50 72 6f 64 | 75 63 74 20 67 72 6f 75 |es:.Prod|uct grou|
|00003c40| 70 73 3a 31 2f 39 30 20 | 3d 0d 4e 53 55 4d 28 20 |ps:1/90 |=.NSUM( |
|00003c50| a5 50 72 6f 64 75 63 74 | 73 3a 28 41 73 73 69 67 |.Product|s:(Assig|
|00003c60| 6e 6d 65 6e 74 0d 3a a5 | 50 72 6f 64 75 63 74 20 |nment.:.|Product |
|00003c70| 67 72 6f 75 70 73 29 3a | 53 61 6c 65 73 3a 31 2f |groups):|Sales:1/|
|00003c80| 39 30 20 29 00 00 00 6d | 43 68 65 63 6b 73 20 74 |90 )...m|Checks t|
|00003c90| 6f 20 73 65 65 20 69 66 | 20 6f 6e 65 20 74 65 78 |o see if| one tex|
|00003ca0| 74 20 0d 69 73 20 63 6f | 6e 74 61 69 6e 65 64 20 |t .is co|ntained |
|00003cb0| 69 6e 20 61 6e 6f 74 68 | 65 72 20 74 65 78 74 0d |in anoth|er text.|
|00003cc0| 0d 49 46 20 28 20 54 65 | 78 74 20 31 20 49 4e 53 |.IF ( Te|xt 1 INS|
|00003cd0| 54 52 20 54 65 78 74 20 | 32 20 29 0d 54 48 45 4e |TR Text |2 ).THEN|
|00003ce0| 20 28 20 2e 2e 2e 20 29 | 20 45 4c 53 45 20 28 20 | ( ... )| ELSE ( |
|00003cf0| 2e 2e 2e 20 29 00 00 00 | 79 43 68 61 6e 67 65 73 |... )...|yChanges|
|00003d00| 20 61 6e 79 20 74 69 6d | 65 20 72 65 66 65 72 65 | any tim|e refere|
|00003d10| 6e 63 65 20 0d 69 6e 74 | 6f 20 61 20 74 65 72 74 |nce .int|o a tert|
|00003d20| 69 61 72 79 20 74 69 6d | 65 20 72 65 66 65 72 65 |iary tim|e refere|
|00003d30| 6e 63 65 0d 0d 54 45 52 | 54 49 41 4c 20 28 20 44 |nce..TER|TIAL ( D|
|00003d40| 61 74 65 20 29 0d 0d 28 | 66 6f 72 20 65 78 61 6d |ate )..(|for exam|
|00003d50| 70 6c 65 2c 20 31 39 39 | 31 20 6f 72 0d 34 2f 31 |ple, 199|1 or.4/1|
|00003d60| 2f 39 31 20 62 65 63 6f | 6d 65 73 20 54 31 2d 39 |/91 beco|mes T1-9|
|00003d70| 31 29 00 00 00 65 41 75 | 74 6f 6d 61 74 69 63 61 |1)...eAu|tomatica|
|00003d80| 6c 6c 79 20 69 6e 73 65 | 72 74 73 20 61 20 70 61 |lly inse|rts a pa|
|00003d90| 67 65 20 0d 6e 75 6d 62 | 65 72 20 77 68 65 6e 20 |ge .numb|er when |
|00003da0| 70 72 69 6e 74 69 6e 67 | 20 0d 0d 50 41 47 45 4e |printing| ..PAGEN|
|00003db0| 55 4d 42 45 52 20 28 20 | 30 20 29 0d 20 28 4e 75 |UMBER ( |0 ). (Nu|
|00003dc0| 6d 62 65 72 69 6e 67 20 | 62 65 67 69 6e 73 20 77 |mbering |begins w|
|00003dd0| 69 74 68 20 70 61 67 65 | 20 31 29 00 00 01 17 54 |ith page| 1)....T|
|00003de0| 68 69 73 20 66 75 6e 63 | 74 69 6f 6e 20 64 65 74 |his func|tion det|
|00003df0| 65 72 6d 69 6e 65 73 20 | 74 68 65 20 6e 75 6d 62 |ermines |the numb|
|00003e00| 65 72 0d 6f 66 20 66 69 | 65 6c 64 73 20 69 6e 20 |er.of fi|elds in |
|00003e10| 61 20 67 69 76 65 6e 20 | 72 61 6e 67 65 2c 0d 6f |a given |range,.o|
|00003e20| 72 20 74 68 65 20 6e 75 | 6d 62 65 72 20 6f 66 20 |r the nu|mber of |
|00003e30| 61 74 74 72 69 62 75 74 | 65 73 20 69 6e 20 61 0d |attribut|es in a.|
|00003e40| 67 69 76 65 6e 20 64 61 | 74 61 62 61 73 65 20 73 |given da|tabase s|
|00003e50| 65 6c 65 63 74 69 6f 6e | 2c 20 74 61 6b 69 6e 67 |election|, taking|
|00003e60| 20 69 6e 74 6f 20 0d 63 | 6f 6e 73 69 64 65 72 61 | into .c|onsidera|
|00003e70| 74 69 6f 6e 20 6f 6e 6c | 79 20 74 68 6f 73 65 20 |tion onl|y those |
|00003e80| 63 65 6c 6c 73 20 74 68 | 61 74 20 0d 61 72 65 20 |cells th|at .are |
|00003e90| 6e 6f 74 20 65 6d 70 74 | 79 0d 0d 43 4f 55 4e 54 |not empt|y..COUNT|
|00003ea0| 56 41 4c 55 45 28 20 46 | 5b 63 2c 72 31 2e 2e 72 |VALUE( F|[c,r1..r|
|00003eb0| 32 5d 20 29 0d 0d 6f 72 | 0d 43 4f 55 4e 54 56 41 |2] )..or|.COUNTVA|
|00003ec0| 4c 55 45 28 a5 50 72 6f | 64 75 63 74 73 3a 28 61 |LUE(.Pro|ducts:(a|
|00003ed0| 6c 6c 29 3a 0d 20 20 20 | 20 20 20 20 20 20 20 20 |ll):.   |        |
|00003ee0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 53 |        |       S|
|00003ef0| 61 6c 65 73 29 29 00 00 | 00 74 41 64 64 73 20 74 |ales))..|.tAdds t|
|00003f00| 77 6f 20 63 65 6c 6c 73 | 20 74 6f 67 65 74 68 65 |wo cells| togethe|
|00003f10| 72 2c 20 61 73 20 6c 6f | 6e 67 20 61 73 0d 62 6f |r, as lo|ng as.bo|
|00003f20| 74 68 20 63 65 6c 6c 73 | 20 61 72 65 20 6e 6f 74 |th cells| are not|
|00003f30| 20 45 4d 50 54 59 3b 20 | 6f 74 68 65 72 77 69 73 | EMPTY; |otherwis|
|00003f40| 65 2c 0d 74 68 65 20 72 | 65 73 75 6c 74 20 69 73 |e,.the r|esult is|
|00003f50| 20 45 4d 50 54 59 20 0d | 0d 56 61 6c 75 65 20 31 | EMPTY .|.Value 1|
|00003f60| 20 50 4c 55 53 20 56 61 | 6c 75 65 20 32 20 00 00 | PLUS Va|lue 2 ..|
|00003f70| 00 7e 53 75 62 74 72 61 | 63 74 73 20 6f 6e 65 20 |.~Subtra|cts one |
|00003f80| 63 65 6c 6c 20 66 72 6f | 6d 20 61 6e 6f 74 68 65 |cell fro|m anothe|
|00003f90| 72 2c 20 0d 61 73 20 6c | 6f 6e 67 20 61 73 20 62 |r, .as l|ong as b|
|00003fa0| 6f 74 68 20 63 65 6c 6c | 73 20 61 72 65 20 6e 6f |oth cell|s are no|
|00003fb0| 74 20 45 4d 50 54 59 3b | 20 0d 6f 74 68 65 72 77 |t EMPTY;| .otherw|
|00003fc0| 69 73 65 2c 20 74 68 65 | 20 72 65 73 75 6c 74 20 |ise, the| result |
|00003fd0| 69 73 20 45 4d 50 54 59 | 0d 0d 56 61 6c 75 65 20 |is EMPTY|..Value |
|00003fe0| 31 20 4d 49 4e 55 53 20 | 56 61 6c 75 65 20 32 20 |1 MINUS |Value 2 |
|00003ff0| 00 00 00 76 54 68 65 20 | 6d 6f 73 74 20 73 70 65 |...vThe |most spe|
|00004000| 63 69 66 69 63 20 65 6c | 65 6d 65 6e 74 20 6f 66 |cific el|ement of|
|00004010| 20 0d 61 20 74 69 6d 65 | 20 72 65 66 65 72 65 6e | .a time| referen|
|00004020| 63 65 20 62 65 63 6f 6d | 65 73 20 0d 61 20 6e 75 |ce becom|es .a nu|
|00004030| 6d 65 72 69 63 61 6c 20 | 76 61 6c 75 65 0d 0d 50 |merical |value..P|
|00004040| 45 52 49 4f 44 20 28 33 | 2f 39 30 29 20 62 65 63 |ERIOD (3|/90) bec|
|00004050| 6f 6d 65 73 20 33 3b 0d | 28 31 2f 33 2f 39 31 29 |omes 3;.|(1/3/91)|
|00004060| 20 62 65 63 6f 6d 65 73 | 20 31 00 00 00 42 52 6f | becomes| 1...BRo|
|00004070| 75 6e 64 69 6e 67 20 6f | 66 66 20 6f 66 0d 61 20 |unding o|ff of.a |
|00004080| 6e 75 6d 65 72 69 63 61 | 6c 20 76 61 6c 75 65 0d |numerica|l value.|
|00004090| 0d 52 4f 55 4e 44 20 28 | 20 56 61 6c 75 65 3b 20 |.ROUND (| Value; |
|000040a0| 44 65 63 69 6d 61 6c 20 | 70 6c 61 63 65 73 20 29 |Decimal |places )|
|000040b0| 00 00 00 65 59 69 65 6c | 64 73 20 74 68 65 20 67 |...eYiel|ds the g|
|000040c0| 69 76 65 6e 20 6e 75 6d | 62 65 72 20 6f 66 20 63 |iven num|ber of c|
|000040d0| 68 61 72 61 63 74 65 72 | 73 20 0d 66 72 6f 6d 20 |haracter|s .from |
|000040e0| 74 68 65 20 6c 65 66 74 | 20 6f 66 20 74 68 65 20 |the left| of the |
|000040f0| 74 65 78 74 20 0d 0d 4c | 45 46 54 20 28 20 54 65 |text ..L|EFT ( Te|
|00004100| 78 74 3b 20 4e 75 6d 62 | 65 72 20 6f 66 20 63 68 |xt; Numb|er of ch|
|00004110| 61 72 61 63 74 65 72 73 | 29 00 00 00 46 4e 61 6d |aracters|)...FNam|
|00004120| 65 20 6f 66 20 74 68 65 | 20 67 72 6f 75 70 20 74 |e of the| group t|
|00004130| 6f 0d 77 68 69 63 68 20 | 61 6e 20 61 74 74 72 69 |o.which |an attri|
|00004140| 62 75 74 65 20 62 65 6c | 6f 6e 67 73 0d 0d 47 52 |bute bel|ongs..GR|
|00004150| 4f 55 50 4e 41 4d 45 20 | 28 41 74 74 72 69 62 75 |OUPNAME |(Attribu|
|00004160| 74 65 29 00 00 00 5c 41 | 20 70 6f 73 69 74 69 76 |te)...\A| positiv|
|00004170| 65 20 76 61 6c 75 65 20 | 77 69 6c 6c 20 62 65 20 |e value |will be |
|00004180| 61 63 63 65 70 74 65 64 | 3b 0d 41 20 6e 65 67 61 |accepted|;.A nega|
|00004190| 74 69 76 65 20 76 61 6c | 75 65 20 79 69 65 6c 64 |tive val|ue yield|
|000041a0| 73 20 61 6e 20 45 4d 50 | 54 59 20 63 65 6c 6c 0d |s an EMP|TY cell.|
|000041b0| 0d 50 4f 53 49 54 49 56 | 45 20 28 20 56 61 6c 75 |.POSITIV|E ( Valu|
|000041c0| 65 20 29 00 00 00 5c 41 | 20 6e 65 67 61 74 69 76 |e )...\A| negativ|
|000041d0| 65 20 76 61 6c 75 65 20 | 77 69 6c 6c 20 62 65 20 |e value |will be |
|000041e0| 61 63 63 65 70 74 65 64 | 3b 0d 41 20 70 6f 73 69 |accepted|;.A posi|
|000041f0| 74 69 76 65 20 76 61 6c | 75 65 20 79 69 65 6c 64 |tive val|ue yield|
|00004200| 73 20 61 6e 20 45 4d 50 | 54 59 20 63 65 6c 6c 0d |s an EMP|TY cell.|
|00004210| 0d 4e 45 47 41 54 49 56 | 45 20 28 20 56 61 6c 75 |.NEGATIV|E ( Valu|
|00004220| 65 20 29 00 00 00 86 43 | 68 61 6e 67 65 73 20 61 |e )....C|hanges a|
|00004230| 6e 79 20 74 69 6d 65 20 | 72 65 66 65 72 65 6e 63 |ny time |referenc|
|00004240| 65 20 0d 69 6e 74 6f 20 | 61 20 6e 69 6e 65 2d 6d |e .into |a nine-m|
|00004250| 6f 6e 74 68 20 74 69 6d | 65 20 72 65 66 65 72 65 |onth tim|e refere|
|00004260| 6e 63 65 0d 0d 54 48 52 | 45 45 51 55 41 52 54 45 |nce..THR|EEQUARTE|
|00004270| 52 59 45 41 52 20 28 20 | 44 61 74 65 20 29 0d 0d |RYEAR ( |Date )..|
|00004280| 28 66 6f 72 20 65 78 61 | 6d 70 6c 65 2c 20 31 39 |(for exa|mple, 19|
|00004290| 39 31 20 6f 72 20 35 2f | 31 2f 39 31 0d 62 65 63 |91 or 5/|1/91.bec|
|000042a0| 6f 6d 65 73 20 44 31 2d | 31 39 39 31 29 00 00 00 |omes D1-|1991)...|
|000042b0| 23 54 69 74 6c 65 20 6f | 66 20 74 68 65 20 77 6f |#Title o|f the wo|
|000042c0| 72 6b 73 68 65 65 74 0d | 0d 54 49 54 4c 45 20 28 |rksheet.|.TITLE (|
|000042d0| 20 30 20 29 00 00 00 d6 | 41 6c 6c 6f 77 73 20 66 | 0 )....|Allows f|
|000042e0| 6f 72 20 61 6e 20 61 74 | 74 72 69 62 75 74 65 20 |or an at|tribute |
|000042f0| 74 6f 20 62 65 20 75 73 | 65 64 0d 61 73 20 61 6e |to be us|ed.as an|
|00004300| 20 61 74 74 72 69 62 75 | 74 65 2c 20 69 6e 73 74 | attribu|te, inst|
|00004310| 65 61 64 20 6f 66 20 61 | 20 0d 64 61 74 61 62 61 |ead of a| .databa|
|00004320| 73 65 20 64 65 66 69 6e | 69 74 69 6f 6e 0d 0d a5 |se defin|ition...|
|00004330| 53 74 6f 72 65 73 3a 20 | 53 61 6c 65 73 20 3d 20 |Stores: |Sales = |
|00004340| 49 46 20 28 a5 53 74 6f | 72 65 73 3a 0d 6d 61 67 |IF (.Sto|res:.mag|
|00004350| 6e 69 74 75 64 65 20 3d | 20 41 54 54 52 49 42 55 |nitude =| ATTRIBU|
|00004360| 54 45 20 28 6c 61 72 67 | 65 29 29 20 0d 54 48 45 |TE (larg|e)) .THE|
|00004370| 4e 20 28 20 2e 2e 2e 20 | 29 20 45 4c 53 45 20 28 |N ( ... |) ELSE (|
|00004380| 20 2e 2e 2e 20 29 0d 0d | 28 20 6c 61 72 67 65 20 | ... )..|( large |
|00004390| 69 73 20 69 6e 20 74 68 | 69 73 20 63 61 73 65 20 |is in th|is case |
|000043a0| 61 6e 20 61 74 74 72 69 | 62 75 74 65 20 29 00 00 |an attri|bute )..|
|000043b0| 00 33 45 78 70 6f 6e 65 | 6e 74 69 61 6c 20 46 75 |.3Expone|ntial Fu|
|000043c0| 6e 63 74 69 6f 6e 0d ca | ca ca ca ca ca ca ca ca |nction..|........|
|000043d0| ca ca ca ca ca ca 0d 45 | 58 50 20 28 20 56 61 6c |.......E|XP ( Val|
|000043e0| 75 65 20 29 20 00 00 00 | c9 53 74 61 6e 64 61 72 |ue ) ...|.Standar|
|000043f0| 64 20 76 61 72 69 61 74 | 69 6f 6e 20 6f 66 20 61 |d variat|ion of a|
|00004400| 20 73 65 6c 65 63 74 69 | 6f 6e 0d 0d 53 44 45 56 | selecti|on..SDEV|
|00004410| 20 28 20 46 5b 31 2e 2e | 31 30 2c 34 5d 20 29 0d | ( F[1..|10,4] ).|
|00004420| 0d 6f 72 0d 53 61 6c 65 | 73 3a 31 2f 39 30 20 3d |.or.Sale|s:1/90 =|
|00004430| 20 53 44 45 56 20 28 20 | a5 50 72 6f 64 75 63 74 | SDEV ( |.Product|
|00004440| 73 0d 3a 28 61 6c 6c 29 | 3a 53 61 6c 65 73 3a 31 |s.:(all)|:Sales:1|
|00004450| 2f 39 30 20 29 0d 0d 6f | 72 0d 53 61 6c 65 73 3a |/90 )..o|r.Sales:|
|00004460| a5 50 72 6f 64 75 63 74 | 20 67 72 6f 75 70 73 3a |.Product| groups:|
|00004470| 31 2f 39 30 20 3d 0d 53 | 44 45 56 20 28 20 a5 50 |1/90 =.S|DEV ( .P|
|00004480| 72 6f 64 75 63 74 73 3a | 28 41 73 73 69 67 6e 6d |roducts:|(Assignm|
|00004490| 65 6e 74 0d 3a a5 50 72 | 6f 64 75 63 74 20 67 72 |ent.:.Pr|oduct gr|
|000044a0| 6f 75 70 73 29 3a 53 61 | 6c 65 73 3a 31 2f 39 30 |oups):Sa|les:1/90|
|000044b0| 20 29 00 00 00 3b 54 68 | 65 20 73 6c 6f 70 65 20 | )...;Th|e slope |
|000044c0| 6f 66 20 74 68 65 20 0d | 72 65 67 72 65 73 73 69 |of the .|regressi|
|000044d0| 6f 6e 20 6c 69 6e 65 0d | 0d 53 4c 4f 50 45 20 28 |on line.|.SLOPE (|
|000044e0| 46 5b 63 31 2e 2e 63 32 | 2c 72 31 2e 2e 72 32 5d |F[c1..c2|,r1..r2]|
|000044f0| 29 00 00 00 f4 4d 61 63 | 72 6f 66 75 6e 63 74 69 |)....Mac|rofuncti|
|00004500| 6f 6e 20 74 68 61 74 20 | 69 6d 70 6f 72 74 73 20 |on that |imports |
|00004510| 0d 61 20 74 65 78 74 20 | 66 69 6c 65 0d 0d 4d 41 |.a text |file..MA|
|00004520| 43 52 4f 46 55 4e 43 54 | 49 4f 4e 3a 20 4e 4f 69 |CROFUNCT|ION: NOi|
|00004530| 3a 20 28 57 6f 72 6b 73 | 68 65 65 74 29 20 3d 0d |: (Works|heet) =.|
|00004540| 41 55 54 4f 49 4d 50 4f | 52 54 28 20 46 5b 63 31 |AUTOIMPO|RT( F[c1|
|00004550| 2e 2e 63 32 2c 72 31 2e | 2e 72 32 5d 3b 0d 20 20 |..c2,r1.|.r2];.  |
|00004560| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00004570| 20 20 20 20 20 20 20 46 | 69 6c 65 20 6e 61 6d 65 |       F|ile name|
|00004580| 20 6f 72 20 30 3b 30 20 | 29 0d 0d 28 30 20 69 6e | or 0;0 |)..(0 in|
|00004590| 73 74 65 61 64 20 6f 66 | 20 66 69 6c 65 20 6e 61 |stead of| file na|
|000045a0| 6d 65 20 3a 0d 6d 61 6e | 75 61 6c 20 66 69 6c 65 |me :.man|ual file|
|000045b0| 20 73 65 6c 65 63 74 69 | 6f 6e 3b 0d 20 46 5b 63 | selecti|on;. F[c|
|000045c0| 31 2e 2e 63 32 2c 72 31 | 2e 2e 72 32 5d 20 64 65 |1..c2,r1|..r2] de|
|000045d0| 66 69 6e 65 73 20 74 68 | 65 20 0d 69 6d 70 6f 72 |fines th|e .impor|
|000045e0| 74 20 66 6f 72 6d 61 74 | 29 00 00 00 51 54 68 65 |t format|)...QThe|
|000045f0| 20 69 6e 74 65 72 63 65 | 70 74 20 6f 66 20 74 68 | interce|pt of th|
|00004600| 65 20 59 2d 61 78 69 73 | 0d 6f 66 20 74 68 65 20 |e Y-axis|.of the |
|00004610| 72 65 67 72 65 73 73 69 | 6f 6e 20 6c 69 6e 65 0d |regressi|on line.|
|00004620| 0d 59 49 4e 54 45 52 43 | 45 50 54 20 28 46 5b 63 |.YINTERC|EPT (F[c|
|00004630| 31 2e 2e 63 32 2c 72 31 | 2e 2e 72 32 5d 29 00 00 |1..c2,r1|..r2])..|
|00004640| 01 0e 4d 61 63 72 6f 66 | 75 6e 63 74 69 6f 6e 20 |..Macrof|unction |
|00004650| 74 6f 20 63 68 6f 73 65 | 20 61 20 73 74 61 74 65 |to chose| a state|
|00004660| 20 6f 66 20 63 61 6c 63 | 75 6c 61 74 69 6f 6e 20 | of calc|ulation |
|00004670| 0d 0d 53 45 54 53 54 41 | 54 45 20 28 20 6e 20 29 |..SETSTA|TE ( n )|
|00004680| 0d 6e 0d 3d 20 31 3a 09 | 42 61 73 65 20 43 61 6c |.n.= 1:.|Base Cal|
|00004690| 63 75 6c 61 74 69 6f 6e | 0d 3d 20 32 3a 09 50 68 |culation|.= 2:.Ph|
|000046a0| 61 73 65 20 32 0d 3d 20 | 33 3a 09 6e 6f 20 63 6f |ase 2.= |3:.no co|
|000046b0| 72 72 65 63 74 69 6f 6e | 20 6f 66 20 72 65 73 75 |rrection| of resu|
|000046c0| 6c 74 73 0d 3d 20 34 3a | 09 63 6f 72 72 65 63 74 |lts.= 4:|.correct|
|000046d0| 69 6f 6e 20 6f 6e 6c 79 | 20 77 69 74 68 20 62 61 |ion only| with ba|
|000046e0| 73 65 20 66 6f 6d 75 6c | 61 73 0d 3d 20 35 3a 09 |se fomul|as.= 5:.|
|000046f0| 63 6f 72 72 65 63 74 69 | 6f 6e 20 77 69 74 68 20 |correcti|on with |
|00004700| 65 76 65 72 79 20 66 6f | 72 6d 75 6c 61 0d 3d 20 |every fo|rmula.= |
|00004710| 36 3a 09 75 70 64 61 74 | 65 20 62 75 69 6c 64 2d |6:.updat|e build-|
|00004720| 75 70 20 61 72 65 61 0d | 3d 20 37 3a 09 62 75 66 |up area.|= 7:.buf|
|00004730| 66 65 72 20 65 6e 74 72 | 69 65 73 0d 3d 20 38 3a |fer entr|ies.= 8:|
|00004740| 09 65 76 61 6c 75 61 74 | 65 20 62 75 66 66 65 72 |.evaluat|e buffer|
|00004750| 00 00 00 52 54 68 65 20 | 63 6f 72 72 65 6c 61 74 |...RThe |correlat|
|00004760| 69 6f 6e 20 63 6f 65 66 | 66 65 63 69 65 6e 74 0d |ion coef|fecient.|
|00004770| 6f 66 20 74 68 65 20 72 | 65 67 72 65 73 73 69 6f |of the r|egressio|
|00004780| 6e 20 6c 69 6e 65 0d 0d | 43 4f 52 52 45 4c 41 54 |n line..|CORRELAT|
|00004790| 49 4f 4e 20 28 46 5b 63 | 31 2e 2e 63 32 2c 72 31 |ION (F[c|1..c2,r1|
|000047a0| 2e 2e 72 32 5d 29 00 00 | 01 0a 4d 61 63 72 6f 66 |..r2])..|..Macrof|
|000047b0| 75 6e 63 74 69 6f 6e 20 | 66 6f 72 20 63 6f 70 79 |unction |for copy|
|000047c0| 69 6e 67 20 74 68 65 20 | 63 6f 6e 74 65 6e 74 73 |ing the |contents|
|000047d0| 0d 6f 66 20 6f 6e 65 20 | 73 65 6c 65 63 74 65 64 |.of one |selected|
|000047e0| 20 61 72 65 61 20 69 6e | 74 6f 20 61 6e 6f 74 68 | area in|to anoth|
|000047f0| 65 72 20 20 0d 0d 4d 41 | 43 52 4f 46 55 4e 43 54 |er  ..MA|CROFUNCT|
|00004800| 49 4f 4e 3a 4e 4f 69 3a | 20 28 57 6f 72 6b 73 68 |ION:NOi:| (Worksh|
|00004810| 65 65 74 29 20 3d 0d 43 | 4f 50 59 20 28 46 5b 63 |eet) =.C|OPY (F[c|
|00004820| 31 2e 2e 63 32 2c 72 31 | 2e 2e 72 32 5d 3b 20 46 |1..c2,r1|..r2]; F|
|00004830| 5b 63 33 2e 2e 63 34 2c | 72 33 2e 2e 72 34 5d 3b |[c3..c4,|r3..r4];|
|00004840| 20 6e 29 0d 0d 6e 20 3d | 20 30 20 20 6c 69 6b 65 | n)..n =| 0  like|
|00004850| 20 43 4f 50 59 20 61 6e | 64 20 50 41 53 54 45 20 | COPY an|d PASTE |
|00004860| 20 66 72 6f 6d 20 74 68 | 65 20 6d 65 6e 75 0d 6e | from th|e menu.n|
|00004870| 20 3d 20 31 20 20 6c 69 | 6b 65 20 43 4f 50 59 20 | = 1  li|ke COPY |
|00004880| 61 6e 64 20 50 41 53 54 | 45 20 53 50 45 43 49 41 |and PAST|E SPECIA|
|00004890| 4c 20 0d ca ca ca ca 20 | 20 56 41 4c 55 45 53 20 |L ..... | VALUES |
|000048a0| 4f 4e 4c 59 20 20 66 72 | 6f 6d 20 74 68 65 20 6d |ONLY  fr|om the m|
|000048b0| 65 6e 75 0d 00 00 00 32 | 4d 61 63 72 6f 66 75 6e |enu....2|Macrofun|
|000048c0| 63 74 69 6f 6e 20 66 6f | 72 20 0d 71 75 69 74 74 |ction fo|r .quitt|
|000048d0| 69 6e 67 20 6d 61 63 43 | 6f 6e 74 72 6f 6c 0d 0d |ing macC|ontrol..|
|000048e0| 51 55 49 54 20 28 20 30 | 20 29 00 00 00 65 4d 61 |QUIT ( 0| )...eMa|
|000048f0| 63 72 6f 66 75 6e 63 74 | 69 6f 6e 20 66 6f 72 20 |crofunct|ion for |
|00004900| 6f 70 65 6e 69 6e 67 0d | 61 20 77 6f 72 6b 73 68 |opening.|a worksh|
|00004910| 65 65 74 0d 0d 4d 41 43 | 52 4f 46 55 4e 43 54 49 |eet..MAC|ROFUNCTI|
|00004920| 4f 4e 20 3a 20 4e 4f 69 | 20 3d 0d 4f 50 45 4e 20 |ON : NOi| =.OPEN |
|00004930| 28 41 54 54 52 49 42 55 | 54 45 0d 20 28 4e 61 6d |(ATTRIBU|TE. (Nam|
|00004940| 65 20 6f 66 20 77 6f 72 | 6b 73 68 65 65 74 29 3b |e of wor|ksheet);|
|00004950| 20 30 29 00 00 00 ce 4c | 61 73 74 20 76 61 6c 75 | 0)....L|ast valu|
|00004960| 65 20 69 6e 20 61 20 73 | 65 6c 65 63 74 65 64 20 |e in a s|elected |
|00004970| 61 72 65 61 0d 0d 4c 53 | 54 56 41 4c 55 45 20 28 |area..LS|TVALUE (|
|00004980| 20 46 5b 31 2e 2e 31 30 | 2c 34 5d 20 29 0d 0d 6f | F[1..10|,4] )..o|
|00004990| 72 0d 53 61 6c 65 73 3a | 31 2f 39 30 20 3d 20 4c |r.Sales:|1/90 = L|
|000049a0| 53 54 56 41 4c 55 45 0d | 28 a5 50 72 6f 64 75 63 |STVALUE.|(.Produc|
|000049b0| 74 73 3a 28 61 6c 6c 29 | 3a 53 61 6c 65 73 3a 31 |ts:(all)|:Sales:1|
|000049c0| 2f 39 30 20 29 0d 0d 6f | 72 0d 53 61 6c 65 73 3a |/90 )..o|r.Sales:|
|000049d0| a5 50 72 6f 64 75 63 74 | 20 67 72 6f 75 70 73 3a |.Product| groups:|
|000049e0| 31 2f 39 30 20 3d 0d 4c | 53 54 56 41 4c 55 45 28 |1/90 =.L|STVALUE(|
|000049f0| 20 a5 50 72 6f 64 75 63 | 74 73 3a 28 41 73 73 69 | .Produc|ts:(Assi|
|00004a00| 67 6e 6d 65 6e 74 0d 3a | a5 50 72 6f 64 75 63 74 |gnment.:|.Product|
|00004a10| 20 67 72 6f 75 70 73 29 | 3a 53 61 6c 65 73 3a 31 | groups)|:Sales:1|
|00004a20| 2f 39 30 20 29 00 00 00 | fe 41 75 74 6f 6d 61 74 |/90 )...|.Automat|
|00004a30| 69 63 61 6c 6c 79 20 6a | 75 6d 70 73 20 74 6f 20 |ically j|umps to |
|00004a40| 73 70 65 63 69 66 69 63 | 0d 63 65 6c 6c 73 20 6f |specific|.cells o|
|00004a50| 66 20 61 20 64 61 74 61 | 20 65 6e 74 72 79 20 77 |f a data| entry w|
|00004a60| 6f 72 6b 73 68 65 65 74 | 0d 6f 72 20 0d 63 61 72 |orksheet|.or .car|
|00004a70| 72 69 65 73 20 6f 75 74 | 20 61 20 4d 61 63 72 6f |ries out| a Macro|
|00004a80| 20 61 66 74 65 72 20 61 | 0d 73 70 65 63 69 66 69 | after a|.specifi|
|00004a90| 63 20 63 65 6c 6c 20 68 | 61 73 20 62 65 65 6e 20 |c cell h|as been |
|00004aa0| 63 68 61 6e 67 65 64 0d | 28 6d 75 73 74 20 62 65 |changed.|(must be|
|00004ab0| 20 64 65 66 69 6e 65 64 | 20 69 6e 20 61 20 66 6c | defined| in a fl|
|00004ac0| 65 78 69 62 6c 65 20 63 | 65 6c 6c 29 0d 0d 4a 55 |exible c|ell)..JU|
|00004ad0| 4d 50 20 28 46 5b 63 31 | 2e 2e 63 32 2c 72 31 2e |MP (F[c1|..c2,r1.|
|00004ae0| 2e 72 32 5d 3b 20 30 20 | 29 0d 20 0d 28 20 46 5b |.r2]; 0 |). .( F[|
|00004af0| 63 31 2e 2e 63 32 2c 72 | 31 2e 2e 72 32 5d 20 67 |c1..c2,r|1..r2] g|
|00004b00| 69 76 65 73 20 74 68 65 | 20 61 72 65 61 20 0d 6f |ives the| area .o|
|00004b10| 66 20 74 68 65 20 4a 55 | 4d 50 20 64 65 66 69 6e |f the JU|MP defin|
|00004b20| 69 74 69 6f 6e 20 29 00 | 00 00 ea 4d 61 63 72 6f |ition ).|...Macro|
|00004b30| 66 75 6e 63 74 69 6f 6e | 20 66 6f 72 20 72 65 70 |function| for rep|
|00004b40| 65 61 74 65 64 20 65 78 | 65 63 75 74 69 6f 6e 0d |eated ex|ecution.|
|00004b50| 6f 66 20 61 20 20 6d 61 | 63 72 6f 2c 20 77 69 74 |of a  ma|cro, wit|
|00004b60| 68 6f 75 74 20 74 68 65 | 20 75 73 65 72 20 68 61 |hout the| user ha|
|00004b70| 76 69 6e 67 20 74 6f 0d | 63 68 61 6e 67 65 20 77 |ving to.|change w|
|00004b80| 6f 72 6b 73 68 65 65 74 | 73 20 6f 72 20 73 77 69 |orksheet|s or swi|
|00004b90| 74 63 68 20 6d 65 6e 75 | 63 65 6c 6c 73 0d 0d 4d |tch menu|cells..M|
|00004ba0| 41 43 52 4f 46 55 4e 43 | 54 49 4f 4e 20 3a 20 4e |ACROFUNC|TION : N|
|00004bb0| 4f 69 20 3a 20 0d 28 57 | 6f 72 6b 73 68 65 65 74 |Oi : .(W|orksheet|
|00004bc0| 29 20 3d 20 20 52 45 50 | 45 41 54 20 0d 28 20 46 |) =  REP|EAT .( F|
|00004bd0| 5b 63 31 2e 2e 63 32 2c | 72 31 2e 2e 72 32 5d 20 |[c1..c2,|r1..r2] |
|00004be0| 29 0d 0d 28 46 5b 63 31 | 2e 2e 63 32 2c 72 31 2e |)..(F[c1|..c2,r1.|
|00004bf0| 2e 72 32 5d 20 63 6f 6e | 74 61 69 6e 73 20 0d 74 |.r2] con|tains .t|
|00004c00| 68 65 20 65 78 61 63 74 | 20 64 65 66 69 6e 69 74 |he exact| definit|
|00004c10| 69 6f 6e 20 29 00 00 00 | b2 59 69 65 6c 64 73 20 |ion )...|.Yields |
|00004c20| 74 68 65 20 70 6f 69 6e | 74 20 69 6e 20 74 69 6d |the poin|t in tim|
|00004c30| 65 20 6f 66 20 74 68 65 | 20 6c 61 73 74 0d 76 61 |e of the| last.va|
|00004c40| 6c 75 65 20 69 6e 73 69 | 64 65 20 61 20 74 69 6d |lue insi|de a tim|
|00004c50| 65 20 69 6e 74 65 72 76 | 61 6c 2c 20 74 68 61 74 |e interv|al, that|
|00004c60| 20 69 73 20 0d 6e 6f 74 | 20 45 4d 50 54 59 0d 0d | is .not| EMPTY..|
|00004c70| 4c 61 73 74 20 6d 6f 6e | 74 68 60 73 20 73 61 6c |Last mon|th`s sal|
|00004c80| 65 73 20 3a 20 a5 50 72 | 6f 64 75 63 74 73 20 3d |es : .Pr|oducts =|
|00004c90| 0d 4c 41 53 54 54 49 4d | 45 20 28 53 61 6c 65 73 |.LASTTIM|E (Sales|
|00004ca0| 3a a5 50 72 6f 64 75 63 | 74 73 0d 3a 31 2f 31 39 |:.Produc|ts.:1/19|
|00004cb0| 30 34 61 3b 20 53 74 61 | 72 74 20 74 69 6d 65 3b |04a; Sta|rt time;|
|00004cc0| 20 45 6e 64 20 74 69 6d | 65 20 29 00 00 00 98 59 | End tim|e )....Y|
|00004cd0| 69 65 6c 64 73 20 74 68 | 65 20 6c 61 73 74 20 76 |ields th|e last v|
|00004ce0| 61 6c 75 65 20 69 6e 20 | 61 20 67 69 76 65 6e 20 |alue in |a given |
|00004cf0| 0d 74 69 6d 65 20 69 6e | 74 65 72 76 61 6c 2c 20 |.time in|terval, |
|00004d00| 74 68 61 74 20 69 73 20 | 6e 6f 74 20 45 4d 50 54 |that is |not EMPT|
|00004d10| 59 0d 0d 4c 61 73 74 20 | 53 61 6c 65 20 3a 20 a5 |Y..Last |Sale : .|
|00004d20| 50 72 6f 64 75 63 74 73 | 20 3d 0d 4c 41 53 54 56 |Products| =.LASTV|
|00004d30| 41 4c 55 45 20 28 20 53 | 61 6c 65 73 3a a5 50 72 |ALUE ( S|ales:.Pr|
|00004d40| 6f 64 75 63 74 73 0d 3a | 31 2f 31 39 30 34 61 3b |oducts.:|1/1904a;|
|00004d50| 20 53 74 61 72 74 20 74 | 69 6d 65 3b 20 45 6e 64 | Start t|ime; End|
|00004d60| 20 74 69 6d 65 20 29 00 | 00 00 89 49 6e 74 65 72 | time ).|...Inter|
|00004d70| 6e 61 6c 20 69 6e 74 65 | 72 65 73 74 20 72 61 74 |nal inte|rest rat|
|00004d80| 65 ca ca ca ca ca ca ca | ca 0d 0d 49 6e 74 65 72 |e.......|...Inter|
|00004d90| 65 73 74 20 72 61 74 65 | 20 3a 20 50 72 6f 6a 65 |est rate| : Proje|
|00004da0| 63 74 20 31 20 3d 0d 49 | 52 41 54 45 20 28 50 72 |ct 1 =.I|RATE (Pr|
|00004db0| 6f 6a 65 63 74 20 31 3a | 20 43 6f 73 74 73 20 0d |oject 1:| Costs .|
|00004dc0| 3a 31 39 30 34 61 3b 20 | 53 74 61 72 74 20 74 69 |:1904a; |Start ti|
|00004dd0| 6d 65 3b 20 45 6e 64 20 | 74 69 6d 65 2c 0d 20 45 |me; End |time,. E|
|00004de0| 73 74 69 6d 61 74 65 64 | 20 76 61 6c 75 65 20 69 |stimated| value i|
|00004df0| 6e 20 25 29 00 00 00 a6 | 50 52 45 53 45 4e 54 20 |n %)....|PRESENT |
|00004e00| 56 41 4c 55 45 20 6f 66 | 20 61 20 73 63 68 65 64 |VALUE of| a sched|
|00004e10| 75 6c 65 20 6f 66 20 0d | 70 61 79 6d 65 6e 74 73 |ule of .|payments|
|00004e20| 20 61 74 20 61 20 67 69 | 76 65 6e 20 69 6e 74 65 | at a gi|ven inte|
|00004e30| 72 65 73 74 20 72 61 74 | 65 0d 0d 50 72 65 73 65 |rest rat|e..Prese|
|00004e40| 6e 74 76 61 6c 75 65 20 | 3a 20 50 72 6f 6a 65 63 |ntvalue |: Projec|
|00004e50| 74 20 31 20 3d 0d 50 56 | 20 28 50 72 6f 6a 65 63 |t 1 =.PV| (Projec|
|00004e60| 74 20 31 3a 20 43 6f 73 | 74 73 20 0d 3a 31 39 30 |t 1: Cos|ts .:190|
|00004e70| 34 61 3b 20 53 74 61 72 | 74 20 74 69 6d 65 3b 20 |4a; Star|t time; |
|00004e80| 45 6e 64 20 74 69 6d 65 | 2c 0d 20 69 6e 74 65 72 |End time|,. inter|
|00004e90| 65 73 74 20 72 61 74 65 | 20 69 6e 20 25 29 00 00 |est rate| in %)..|
|00004ea0| 00 a4 46 55 54 55 52 45 | 20 56 41 4c 55 45 20 6f |..FUTURE| VALUE o|
|00004eb0| 66 20 61 20 73 63 68 65 | 64 75 6c 65 20 6f 66 20 |f a sche|dule of |
|00004ec0| 0d 70 61 79 6d 65 6e 74 | 73 20 61 74 20 61 20 67 |.payment|s at a g|
|00004ed0| 69 76 65 6e 20 69 6e 74 | 65 72 65 73 74 20 72 61 |iven int|erest ra|
|00004ee0| 74 65 0d 0d 46 75 74 75 | 72 65 76 61 6c 75 65 20 |te..Futu|revalue |
|00004ef0| 3a 20 50 72 6f 6a 65 63 | 74 20 31 20 3d 0d 46 56 |: Projec|t 1 =.FV|
|00004f00| 20 28 50 72 6f 6a 65 63 | 74 20 31 3a 20 43 6f 73 | (Projec|t 1: Cos|
|00004f10| 74 73 20 0d 3a 31 39 30 | 34 61 3b 20 53 74 61 72 |ts .:190|4a; Star|
|00004f20| 74 20 74 69 6d 65 3b 20 | 45 6e 64 20 74 69 6d 65 |t time; |End time|
|00004f30| 2c 0d 20 69 6e 74 65 72 | 65 73 74 20 72 61 74 65 |,. inter|est rate|
|00004f40| 20 69 6e 20 25 29 00 00 | 00 b6 50 52 45 53 45 4e | in %)..|..PRESEN|
|00004f50| 54 20 56 41 4c 55 45 20 | 77 69 74 68 20 61 20 67 |T VALUE |with a g|
|00004f60| 69 76 65 6e 20 66 69 72 | 73 74 0d 70 61 79 6d 65 |iven fir|st.payme|
|00004f70| 6e 74 20 61 6e 64 20 61 | 20 73 70 65 63 69 66 69 |nt and a| specifi|
|00004f80| 63 20 6e 75 6d 62 65 72 | 20 6f 66 0d 6c 61 74 65 |c number| of.late|
|00004f90| 72 20 70 61 79 6d 65 6e | 74 73 0d 0d 0d 50 72 65 |r paymen|ts...Pre|
|00004fa0| 73 65 6e 74 76 61 6c 75 | 65 20 20 3d 0d 4e 50 56 |sentvalu|e  =.NPV|
|00004fb0| 20 28 46 69 72 73 74 20 | 70 61 79 6d 65 6e 74 3b | (First |payment;|
|00004fc0| 20 66 6f 6c 6c 6f 77 69 | 6e 67 20 70 61 79 6d 65 | followi|ng payme|
|00004fd0| 6e 74 3b 0d 4e 75 6d 62 | 65 72 20 6f 66 20 66 6f |nt;.Numb|er of fo|
|00004fe0| 6c 6c 6f 77 69 6e 67 20 | 70 61 79 6d 65 6e 74 73 |llowing |payments|
|00004ff0| 3b 0d 49 6e 74 65 72 65 | 73 74 20 72 61 74 65 29 |;.Intere|st rate)|
|00005000| 00 00 00 b7 46 55 54 55 | 52 45 20 56 41 4c 55 45 |....FUTU|RE VALUE|
|00005010| 20 77 69 74 68 20 61 20 | 67 69 76 65 6e 20 66 69 | with a |given fi|
|00005020| 72 73 74 0d 70 61 79 6d | 65 6e 74 20 61 6e 64 20 |rst.paym|ent and |
|00005030| 61 20 73 70 65 63 69 66 | 69 63 20 6e 75 6d 62 65 |a specif|ic numbe|
|00005040| 72 20 6f 66 0d 6c 61 74 | 65 72 20 70 61 79 6d 65 |r of.lat|er payme|
|00005050| 6e 74 73 0d 0d 0d 46 75 | 74 75 72 65 76 61 6c 75 |nts...Fu|turevalu|
|00005060| 65 20 20 3d 0d 4e 46 56 | 20 20 28 46 69 72 73 74 |e  =.NFV|  (First|
|00005070| 20 70 61 79 6d 65 6e 74 | 3b 20 66 6f 6c 6c 6f 77 | payment|; follow|
|00005080| 69 6e 67 20 0d 70 61 79 | 6d 65 6e 74 3b 20 4e 75 |ing .pay|ment; Nu|
|00005090| 6d 62 65 72 20 6f 66 20 | 66 6f 6c 6c 6f 77 69 6e |mber of |followin|
|000050a0| 67 20 0d 70 61 79 6d 65 | 6e 74 73 3b 20 49 6e 74 |g .payme|nts; Int|
|000050b0| 65 72 65 73 74 20 72 61 | 74 65 29 00 00 00 98 4d |erest ra|te)....M|
|000050c0| 61 63 72 6f 66 75 6e 63 | 74 69 6f 6e 20 66 6f 72 |acrofunc|tion for|
|000050d0| 20 61 75 74 6f 6d 61 74 | 69 63 61 6c 6c 79 20 63 | automat|ically c|
|000050e0| 72 65 61 74 69 6e 67 0d | 61 73 73 69 67 6e 6d 65 |reating.|assignme|
|000050f0| 6e 74 73 20 64 75 72 69 | 6e 67 20 61 20 64 61 74 |nts duri|ng a dat|
|00005100| 61 20 69 6d 70 6f 72 74 | 0d 0d 41 43 54 49 56 41 |a import|..ACTIVA|
|00005110| 54 45 20 28 41 73 73 69 | 67 6e 6d 65 6e 74 20 64 |TE (Assi|gnment d|
|00005120| 65 66 69 6e 69 74 69 6f | 6e 3b 20 0d 20 20 20 20 |efinitio|n; .    |
|00005130| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 47 72 |        |      Gr|
|00005140| 6f 75 70 20 74 6f 20 62 | 65 20 61 73 73 69 67 6e |oup to b|e assign|
|00005150| 65 64 3b 20 30 29 20 00 | 00 00 50 4d 61 63 72 6f |ed; 0) .|..PMacro|
|00005160| 66 75 6e 63 74 69 6f 6e | 20 74 68 61 74 20 73 65 |function| that se|
|00005170| 6e 64 73 0d 61 20 71 75 | 65 72 79 20 74 6f 20 61 |nds.a qu|ery to a|
|00005180| 20 68 6f 73 74 20 20 20 | 20 20 20 20 20 20 20 20 | host   |        |
|00005190| 20 20 0d 0d 53 45 4e 44 | 20 28 51 75 65 72 79 3b |  ..SEND| (Query;|
|000051a0| 20 46 69 6c 65 20 6e 61 | 6d 65 29 00 00 00 87 4d | File na|me)....M|
|000051b0| 61 63 72 6f 66 75 6e 63 | 74 69 6f 6e 20 66 6f 72 |acrofunc|tion for|
|000051c0| 20 61 75 74 6f 6d 61 74 | 69 63 61 6c 6c 79 20 0d | automat|ically .|
|000051d0| 62 75 69 6c 64 69 6e 67 | 20 75 70 20 61 20 63 6f |building| up a co|
|000051e0| 6e 6e 65 63 74 69 6f 6e | 20 74 6f 20 61 20 68 6f |nnection| to a ho|
|000051f0| 73 74 0d 20 0d 43 4f 4e | 4e 45 43 54 20 28 44 61 |st. .CON|NECT (Da|
|00005200| 74 61 62 61 73 65 20 65 | 78 74 65 6e 73 69 6f 6e |tabase e|xtension|
|00005210| 3b 20 0d 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |; .     |        |
|00005220| 20 20 20 20 20 20 48 6f | 73 74 3b 20 41 64 64 69 |      Ho|st; Addi|
|00005230| 74 69 6f 6e 20 29 00 00 | 00 1c 46 6f 72 20 64 65 |tion )..|..For de|
|00005240| 66 69 6e 69 6e 67 20 61 | 20 64 61 74 61 62 61 73 |fining a| databas|
|00005250| 65 20 63 65 6c 6c 00 00 | 00 16 46 6f 72 20 64 65 |e cell..|..For de|
|00005260| 66 69 6e 69 6e 67 20 61 | 20 66 6f 72 6d 75 6c 61 |fining a| formula|
|00005270| 00 00 00 29 46 6f 72 20 | 64 65 66 69 6e 69 6e 67 |...)For |defining|
|00005280| 20 61 6e 20 61 74 74 72 | 69 62 75 74 65 2d 20 6f | an attr|ibute- o|
|00005290| 72 20 61 20 6d 65 6e 75 | 20 63 65 6c 6c 00 00 00 |r a menu| cell...|
|000052a0| 18 46 6f 72 20 64 65 66 | 69 6e 69 6e 67 20 61 20 |.For def|ining a |
|000052b0| 74 69 6d 65 20 63 65 6c | 6c 00 00 00 2d 63 61 6e |time cel|l...-can|
|000052c0| 63 65 6c 73 20 74 68 65 | 20 69 6e 70 75 74 2c 20 |cels the| input, |
|000052d0| 77 69 74 68 6f 75 74 20 | 73 61 76 69 6e 67 20 74 |without |saving t|
|000052e0| 68 65 20 63 68 61 6e 67 | 65 73 00 00 00 19 51 75 |he chang|es....Qu|
|000052f0| 69 74 73 20 61 6e 64 20 | 73 61 76 65 73 20 74 68 |its and |saves th|
|00005300| 65 20 69 6e 70 75 74 00 | 00 00 1a 4f 70 65 6e 73 |e input.|...Opens|
|00005310| 20 74 68 65 20 61 74 74 | 72 69 62 75 74 65 20 77 | the att|ribute w|
|00005320| 69 6e 64 6f 77 00 00 00 | d7 44 65 66 69 6e 65 73 |indow...|.Defines|
|00005330| 20 6f 6e 20 77 68 69 63 | 68 20 73 69 64 65 73 20 | on whic|h sides |
|00005340| 6f 66 20 61 20 67 72 61 | 70 68 69 63 20 0d 74 68 |of a gra|phic .th|
|00005350| 65 72 65 20 73 68 6f 75 | 6c 64 20 62 65 20 62 6f |ere shou|ld be bo|
|00005360| 72 64 65 72 73 2c 20 61 | 6e 64 20 68 6f 77 20 6c |rders, a|nd how l|
|00005370| 61 72 67 65 0d 74 68 65 | 79 20 73 68 6f 75 6c 64 |arge.the|y should|
|00005380| 20 62 65 20 28 6f 6e 6c | 79 20 77 69 74 68 20 32 | be (onl|y with 2|
|00005390| 44 2d 47 72 61 70 68 69 | 63 73 29 2e 0d 50 69 65 |D-Graphi|cs)..Pie|
|000053a0| 20 63 68 61 72 74 73 20 | 77 69 74 68 20 64 65 70 | charts |with dep|
|000053b0| 74 68 20 63 61 6e 20 62 | 65 20 76 69 65 77 65 64 |th can b|e viewed|
|000053c0| 20 66 72 6f 6d 0d 76 61 | 72 69 6f 75 73 20 61 6e | from.va|rious an|
|000053d0| 67 6c 65 73 20 62 79 20 | 64 65 66 69 6e 69 6e 67 |gles by |defining|
|000053e0| 20 74 68 65 20 75 70 70 | 65 72 20 61 6e 64 20 0d | the upp|er and .|
|000053f0| 6c 6f 77 65 72 20 62 6f | 72 64 65 72 73 20 20 0d |lower bo|rders  .|
|00005400| 00 00 00 f8 47 69 76 65 | 73 20 32 44 2d 67 72 61 |....Give|s 2D-gra|
|00005410| 70 68 69 63 73 20 61 20 | 73 70 61 74 69 61 6c 20 |phics a |spatial |
|00005420| 63 68 61 72 61 63 74 65 | 72 2e 20 54 6f 20 67 69 |characte|r. To gi|
|00005430| 76 65 0d 64 65 70 74 68 | 20 6e 6f 74 20 6f 6e 6c |ve.depth| not onl|
|00005440| 79 20 74 6f 20 74 68 65 | 20 61 78 69 73 2c 20 62 |y to the| axis, b|
|00005450| 75 74 20 61 6c 73 6f 20 | 74 6f 20 74 68 65 20 0d |ut also |to the .|
|00005460| 67 72 61 70 68 69 63 20 | 69 74 73 65 6c 66 2c 20 |graphic |itself, |
|00005470| 61 20 64 65 70 74 68 20 | 72 61 6e 67 65 20 6d 75 |a depth |range mu|
|00005480| 73 74 20 62 65 20 63 68 | 6f 73 65 6e 0d 28 62 79 |st be ch|osen.(by|
|00005490| 20 63 6c 69 63 6b 69 6e | 67 20 6f 6e 20 4f 50 54 | clickin|g on OPT|
|000054a0| 49 4f 4e 29 2e 20 20 0d | 0d 57 69 74 68 20 33 44 |ION).  .|.With 3D|
|000054b0| 2d 63 6f 6e 74 6f 75 72 | 2d 67 72 61 70 68 69 63 |-contour|-graphic|
|000054c0| 73 2c 20 74 68 65 20 6e | 75 6d 62 65 72 20 6f 66 |s, the n|umber of|
|000054d0| 20 0d 63 6f 6e 74 6f 75 | 72 20 6c 69 6e 65 73 20 | .contou|r lines |
|000054e0| 69 73 20 65 6e 74 65 72 | 65 64 20 69 6e 20 74 68 |is enter|ed in th|
|000054f0| 69 73 20 66 69 65 6c 64 | 20 0d 0d 0d 00 00 00 ed |is field| .......|
|00005500| 44 65 66 69 6e 65 73 20 | 74 68 65 20 73 69 7a 65 |Defines |the size|
|00005510| 20 6f 66 20 61 20 73 69 | 6e 67 6c 65 20 61 78 69 | of a si|ngle axi|
|00005520| 73 20 69 6e 20 70 65 72 | 63 65 6e 74 0d 6f 66 20 |s in per|cent.of |
|00005530| 74 68 65 20 64 65 66 61 | 75 6c 74 2d 76 61 6c 75 |the defa|ult-valu|
|00005540| 65 2e 20 20 54 68 69 73 | 20 61 6c 6c 6f 77 73 20 |e.  This| allows |
|00005550| 74 68 65 20 75 73 65 72 | 0d 74 6f 20 65 6e 6c 61 |the user|.to enla|
|00005560| 72 67 65 20 6f 72 20 72 | 65 64 75 63 65 20 74 68 |rge or r|educe th|
|00005570| 65 20 77 68 6f 6c 65 20 | 67 72 61 70 68 69 63 2e |e whole |graphic.|
|00005580| 0d 0d 49 74 20 69 73 20 | 65 61 73 69 65 72 20 74 |..It is |easier t|
|00005590| 6f 20 73 65 6c 65 63 74 | 20 74 68 65 20 67 72 61 |o select| the gra|
|000055a0| 70 68 69 63 20 61 6e 64 | 20 75 73 65 0d 74 68 65 |phic and| use.the|
|000055b0| 20 75 70 70 65 72 20 72 | 6f 77 20 6f 66 20 74 68 | upper r|ow of th|
|000055c0| 65 20 6e 75 6d 65 72 69 | 63 20 6b 65 79 70 61 64 |e numeri|c keypad|
|000055d0| 20 6f 72 20 0d 74 6f 20 | 70 75 73 68 20 74 68 65 | or .to |push the|
|000055e0| 20 2b 20 6f 72 20 2d 20 | 6b 65 79 73 20 00 00 00 | + or - |keys ...|
|000055f0| f9 45 73 74 61 62 6c 69 | 73 68 65 73 20 77 68 61 |.Establi|shes wha|
|00005600| 74 20 70 65 72 63 65 6e | 74 20 6f 66 20 74 68 65 |t percen|t of the|
|00005610| 20 61 78 69 73 20 69 73 | 20 75 73 65 64 20 69 6e | axis is| used in|
|00005620| 20 67 72 61 70 68 69 63 | 61 6c 6c 79 20 64 65 70 | graphic|ally dep|
|00005630| 69 63 74 69 6e 67 20 74 | 68 65 20 64 61 74 61 2e |icting t|he data.|
|00005640| 0d 0d 31 30 30 20 25 20 | 6d 65 61 6e 73 20 74 68 |..100 % |means th|
|00005650| 61 74 20 74 68 65 20 68 | 69 67 68 65 73 74 20 64 |at the h|ighest d|
|00005660| 61 74 61 20 76 61 6c 75 | 65 20 69 73 20 74 68 65 |ata valu|e is the|
|00005670| 20 73 61 6d 65 20 68 65 | 69 67 68 74 20 61 73 20 | same he|ight as |
|00005680| 74 68 65 20 68 69 67 68 | 65 73 74 20 61 78 69 73 |the high|est axis|
|00005690| 20 76 61 6c 75 65 2e 0d | 35 30 20 25 20 6d 65 61 | value..|50 % mea|
|000056a0| 6e 73 20 74 68 61 74 20 | 74 68 65 20 68 69 67 68 |ns that |the high|
|000056b0| 65 73 74 20 61 78 69 73 | 20 76 61 6c 75 65 20 69 |est axis| value i|
|000056c0| 73 20 74 77 69 63 65 20 | 61 73 20 68 69 67 68 20 |s twice |as high |
|000056d0| 61 73 20 74 68 65 20 68 | 69 67 68 65 73 74 20 64 |as the h|ighest d|
|000056e0| 61 74 61 20 76 61 6c 75 | 65 2e 00 00 00 d7 45 73 |ata valu|e.....Es|
|000056f0| 74 61 62 6c 69 73 68 65 | 73 20 74 68 65 20 70 65 |tablishe|s the pe|
|00005700| 72 63 65 6e 74 61 67 65 | 20 74 68 61 74 20 74 68 |rcentage| that th|
|00005710| 65 20 67 72 61 70 68 69 | 63 20 6f 62 6a 65 63 74 |e graphi|c object|
|00005720| 73 20 28 63 6f 6c 75 6d | 6e 73 2c 20 65 74 63 2e |s (colum|ns, etc.|
|00005730| 29 20 73 68 6f 75 6c 64 | 20 66 69 6c 6c 0d 66 72 |) should| fill.fr|
|00005740| 6f 6d 20 74 68 65 20 73 | 70 61 63 65 20 74 68 61 |om the s|pace tha|
|00005750| 74 20 69 73 20 61 76 61 | 69 6c 61 62 6c 65 20 6f |t is ava|ilable o|
|00005760| 6e 20 74 68 65 20 61 78 | 69 73 2e 0d 0d 54 68 69 |n the ax|is...Thi|
|00005770| 73 20 61 6c 6c 6f 77 73 | 20 74 68 65 20 6f 62 6a |s allows| the obj|
|00005780| 65 63 74 73 20 74 6f 20 | 62 65 20 65 6e 6c 61 72 |ects to |be enlar|
|00005790| 67 65 64 20 77 69 74 68 | 6f 75 74 20 68 61 76 69 |ged with|out havi|
|000057a0| 6e 67 20 74 6f 20 63 68 | 61 6e 67 65 20 74 68 65 |ng to ch|ange the|
|000057b0| 20 73 69 7a 65 20 6f 66 | 20 74 68 65 20 67 72 61 | size of| the gra|
|000057c0| 70 68 69 63 2e 00 00 00 | ed 45 73 74 61 62 6c 69 |phic....|.Establi|
|000057d0| 73 68 65 73 20 74 68 65 | 20 6e 75 6d 62 65 72 20 |shes the| number |
|000057e0| 6f 66 20 64 65 67 72 65 | 65 73 20 74 68 61 74 20 |of degre|es that |
|000057f0| 74 68 65 20 67 72 61 70 | 68 20 73 68 6f 75 6c 64 |the grap|h should|
|00005800| 20 72 6f 74 61 74 65 20 | 6f 6e 20 74 68 65 20 61 | rotate |on the a|
|00005810| 78 69 73 2e 0d 54 68 69 | 73 20 65 6e 61 62 6c 65 |xis..Thi|s enable|
|00005820| 73 20 74 68 65 20 75 73 | 65 72 20 74 6f 20 63 68 |s the us|er to ch|
|00005830| 61 6e 67 65 20 74 68 65 | 20 76 69 73 75 61 6c 20 |ange the| visual |
|00005840| 61 6e 67 6c 65 20 6f 66 | 20 74 68 65 20 67 72 61 |angle of| the gra|
|00005850| 70 68 2e 0d 0d 49 74 20 | 69 73 20 65 61 73 69 65 |ph...It |is easie|
|00005860| 72 20 74 6f 20 73 65 6c | 65 63 74 20 74 68 65 20 |r to sel|ect the |
|00005870| 67 72 61 70 68 69 63 2c | 20 61 6e 64 20 74 68 65 |graphic,| and the|
|00005880| 6e 20 6d 61 6b 65 20 74 | 68 65 20 61 64 6a 75 73 |n make t|he adjus|
|00005890| 74 6d 65 6e 74 20 77 69 | 74 68 20 74 68 65 20 68 |tment wi|th the h|
|000058a0| 65 6c 70 20 6f 66 20 74 | 68 65 20 61 72 72 6f 77 |elp of t|he arrow|
|000058b0| 20 6b 65 79 73 2e 00 00 | 01 3a 4f 62 6a 65 63 74 | keys...|.:Object|
|000058c0| 73 20 74 68 61 74 20 61 | 72 65 20 66 61 72 74 68 |s that a|re farth|
|000058d0| 65 72 20 61 77 61 79 20 | 73 65 65 6d 20 74 6f 20 |er away |seem to |
|000058e0| 62 65 20 73 6d 61 6c 6c | 65 72 20 74 68 61 6e 20 |be small|er than |
|000058f0| 73 69 6d 69 6c 61 72 20 | 6f 62 6a 65 63 74 73 20 |similar |objects |
|00005900| 74 68 61 74 20 61 72 65 | 20 6e 65 61 72 65 72 2e |that are| nearer.|
|00005910| 0d 42 79 20 63 68 61 6e | 67 69 6e 67 20 74 68 65 |.By chan|ging the|
|00005920| 20 66 6f 63 61 6c 20 64 | 69 73 74 61 6e 63 65 2c | focal d|istance,|
|00005930| 20 74 68 65 20 73 74 72 | 65 6e 67 74 68 20 6f 66 | the str|ength of|
|00005940| 20 74 68 69 73 20 65 66 | 66 65 63 74 20 63 61 6e | this ef|fect can|
|00005950| 20 62 65 20 63 68 61 6e | 67 65 64 2e 0d 0d 41 20 | be chan|ged...A |
|00005960| 66 6f 63 61 6c 20 64 69 | 73 74 61 6e 63 65 20 6f |focal di|stance o|
|00005970| 66 20 7a 65 72 6f 20 72 | 65 73 75 6c 74 73 20 69 |f zero r|esults i|
|00005980| 6e 20 6e 65 61 72 20 61 | 6e 64 20 64 69 73 74 61 |n near a|nd dista|
|00005990| 6e 74 20 6f 62 6a 65 63 | 74 73 20 61 70 70 65 61 |nt objec|ts appea|
|000059a0| 72 69 6e 67 20 74 6f 20 | 62 65 20 74 68 65 20 73 |ring to |be the s|
|000059b0| 61 6d 65 20 73 69 7a 65 | 2e 0d 36 30 20 69 73 20 |ame size|..60 is |
|000059c0| 74 68 65 20 68 69 67 68 | 65 73 74 20 76 61 6c 75 |the high|est valu|
|000059d0| 65 20 77 68 69 63 68 20 | 70 72 6f 64 75 63 65 73 |e which |produces|
|000059e0| 20 6d 65 61 6e 69 6e 67 | 66 75 6c 20 72 65 73 75 | meaning|ful resu|
|000059f0| 6c 74 73 2e 00 00 01 18 | 45 73 74 61 62 6c 69 73 |lts.....|Establis|
|00005a00| 68 65 73 20 77 68 61 74 | 20 70 65 72 63 65 6e 74 |hes what| percent|
|00005a10| 61 67 65 20 74 68 65 20 | 67 72 61 70 68 69 63 2d |age the |graphic-|
|00005a20| 6f 62 6a 65 63 74 20 67 | 72 6f 75 70 73 20 28 63 |object g|roups (c|
|00005a30| 6f 6c 75 6d 6e 20 67 72 | 6f 75 70 73 20 65 74 63 |olumn gr|oups etc|
|00005a40| 2e 29 20 77 69 6c 6c 20 | 66 69 6c 6c 20 6f 66 20 |.) will |fill of |
|00005a50| 74 68 65 20 73 70 61 63 | 65 20 74 68 61 74 20 0d |the spac|e that .|
|00005a60| 69 73 20 61 76 61 69 6c | 61 62 6c 65 20 66 6f 72 |is avail|able for|
|00005a70| 20 74 68 65 6d 2e 0d 0d | 54 68 69 73 20 61 6c 6c | them...|This all|
|00005a80| 6f 77 73 20 74 68 65 20 | 77 69 64 74 68 20 6f 66 |ows the |width of|
|00005a90| 20 74 68 65 20 6f 62 6a | 65 63 74 20 67 72 6f 75 | the obj|ect grou|
|00005aa0| 70 73 20 74 6f 20 62 65 | 20 63 68 61 6e 67 65 64 |ps to be| changed|
|00005ab0| 20 77 69 74 68 6f 75 74 | 20 63 68 61 6e 67 69 6e | without| changin|
|00005ac0| 67 20 74 68 65 20 73 69 | 7a 65 20 6f 66 20 74 68 |g the si|ze of th|
|00005ad0| 65 20 67 72 61 70 68 20 | 6f 72 20 74 68 65 0d 73 |e graph |or the.s|
|00005ae0| 69 7a 65 20 6f 66 20 74 | 68 65 20 69 6e 64 69 76 |ize of t|he indiv|
|00005af0| 69 64 75 61 6c 20 6f 62 | 6a 65 63 74 73 20 28 63 |idual ob|jects (c|
|00005b00| 6f 6c 75 6d 6e 73 2c 20 | 65 74 63 2e 29 2e 20 20 |olumns, |etc.).  |
|00005b10| 00 00 00 d6 45 73 74 61 | 62 6c 69 73 68 65 73 20 |....Esta|blishes |
|00005b20| 77 68 61 74 20 70 65 72 | 63 65 6e 74 61 67 65 20 |what per|centage |
|00005b30| 74 68 65 20 69 6e 64 69 | 76 69 64 75 61 6c 20 6f |the indi|vidual o|
|00005b40| 62 6a 65 63 74 20 28 63 | 6f 6c 75 6d 20 65 74 63 |bject (c|olum etc|
|00005b50| 2e 29 20 77 69 6c 6c 20 | 66 69 6c 6c 20 6f 66 20 |.) will |fill of |
|00005b60| 74 68 65 20 73 70 61 63 | 65 20 74 68 61 74 0d 69 |the spac|e that.i|
|00005b70| 73 20 61 76 61 69 6c 61 | 62 6c 65 20 66 6f 72 20 |s availa|ble for |
|00005b80| 69 74 2e 0d 0d 54 68 69 | 73 20 61 6c 6c 6f 77 73 |it...Thi|s allows|
|00005b90| 20 74 68 65 20 77 69 64 | 74 68 20 6f 66 20 74 68 | the wid|th of th|
|00005ba0| 65 20 69 6e 64 69 76 69 | 64 75 61 6c 20 6f 62 6a |e indivi|dual obj|
|00005bb0| 65 63 74 73 20 74 6f 20 | 62 65 20 63 68 61 6e 67 |ects to |be chang|
|00005bc0| 65 64 20 77 69 74 68 6f | 75 74 20 63 68 61 6e 67 |ed witho|ut chang|
|00005bd0| 69 6e 67 20 74 68 65 20 | 73 69 7a 65 20 6f 66 20 |ing the |size of |
|00005be0| 74 68 65 20 67 72 61 70 | 68 2e 00 00 01 1a 50 72 |the grap|h.....Pr|
|00005bf0| 6f 76 69 64 65 64 20 74 | 68 61 74 20 61 20 76 61 |ovided t|hat a va|
|00005c00| 6c 75 65 20 6c 61 72 67 | 65 72 20 74 68 61 6e 20 |lue larg|er than |
|00005c10| 7a 65 72 6f 20 69 73 20 | 67 69 76 65 6e 2c 20 74 |zero is |given, t|
|00005c20| 68 65 20 44 45 50 54 48 | 20 6f 70 74 69 6f 6e 20 |he DEPTH| option |
|00005c30| 65 73 74 61 62 6c 69 73 | 68 65 73 20 69 6e 20 77 |establis|hes in w|
|00005c40| 68 69 63 68 20 61 72 65 | 61 20 6f 66 20 74 68 69 |hich are|a of thi|
|00005c50| 73 20 64 65 70 74 68 0d | 74 68 65 20 67 72 61 70 |s depth.|the grap|
|00005c60| 68 69 63 20 6f 62 6a 65 | 63 74 73 20 28 63 6f 6c |hic obje|cts (col|
|00005c70| 75 6d 6e 73 20 65 74 63 | 2e 20 29 20 77 69 6c 6c |umns etc|. ) will|
|00005c80| 20 6c 69 65 2e 0d 0d 49 | 74 20 69 73 20 69 6d 70 | lie...I|t is imp|
|00005c90| 6f 72 74 61 6e 74 20 74 | 6f 20 6e 6f 74 65 20 68 |ortant t|o note h|
|00005ca0| 65 72 65 20 74 68 61 74 | 20 74 68 65 20 69 6e 73 |ere that| the ins|
|00005cb0| 65 72 74 65 64 20 76 61 | 6c 75 65 20 6d 75 73 74 |erted va|lue must|
|00005cc0| 20 62 65 20 62 65 74 77 | 65 65 6e 20 7a 65 72 6f | be betw|een zero|
|00005cd0| 20 61 6e 64 20 74 68 65 | 20 64 65 70 74 68 20 76 | and the| depth v|
|00005ce0| 61 6c 75 65 2c 20 69 66 | 20 74 68 65 0d 20 44 45 |alue, if| the. DE|
|00005cf0| 50 54 48 20 66 75 6e 63 | 74 69 6f 6e 20 69 73 20 |PTH func|tion is |
|00005d00| 74 6f 20 77 6f 72 6b 2e | 00 00 00 e2 53 68 69 66 |to work.|....Shif|
|00005d10| 74 73 20 73 79 6d 62 6f | 6c 73 20 6f 66 20 73 79 |ts symbo|ls of sy|
|00005d20| 6d 62 6f 6c 2d 67 72 61 | 70 68 69 63 73 2e 0d 50 |mbol-gra|phics..P|
|00005d30| 6f 73 69 74 69 76 65 20 | 76 61 6c 75 65 73 20 6c |ositive |values l|
|00005d40| 65 61 64 20 74 6f 20 61 | 20 73 68 69 66 74 20 75 |ead to a| shift u|
|00005d50| 70 20 61 6e 64 20 74 6f | 20 74 68 65 20 72 69 67 |p and to| the rig|
|00005d60| 68 74 2c 20 61 6e 64 20 | 6e 65 67 61 74 69 76 65 |ht, and |negative|
|00005d70| 20 76 61 6c 75 65 73 20 | 76 69 63 65 2d 76 65 72 | values |vice-ver|
|00005d80| 73 61 2e 0d 0d 49 6e 20 | 61 6c 6c 20 6f 74 68 65 |sa...In |all othe|
|00005d90| 72 20 67 72 61 70 68 69 | 63 20 74 79 70 65 73 2c |r graphi|c types,|
|00005da0| 20 70 72 6f 76 69 64 65 | 64 20 74 68 61 74 20 74 | provide|d that t|
|00005db0| 68 65 20 6f 70 74 69 6f | 6e 20 56 41 4c 55 45 53 |he optio|n VALUES|
|00005dc0| 20 69 73 20 73 65 6c 65 | 63 74 65 64 2c 20 74 68 | is sele|cted, th|
|00005dd0| 65 20 64 69 73 70 6c 61 | 79 65 64 20 76 61 6c 75 |e displa|yed valu|
|00005de0| 65 73 20 77 69 6c 6c 20 | 73 68 69 66 74 2e 00 00 |es will |shift...|
|00005df0| 01 42 45 73 74 61 62 6c | 69 73 68 65 73 20 74 68 |.BEstabl|ishes th|
|00005e00| 65 20 63 6f 6c 75 6d 6e | 20 61 6e 64 20 74 68 65 |e column| and the|
|00005e10| 20 72 6f 77 2c 20 69 6e | 20 77 68 69 63 68 20 74 | row, in| which t|
|00005e20| 68 65 20 75 70 70 65 72 | 20 6c 65 66 74 2d 68 61 |he upper| left-ha|
|00005e30| 6e 64 20 63 6f 72 6e 65 | 72 20 6f 66 20 74 68 65 |nd corne|r of the|
|00005e40| 20 61 64 64 69 74 69 6f | 6e 61 6c 0d 69 6e 66 6f | additio|nal.info|
|00005e50| 72 6d 61 74 69 6f 6e 20 | 66 6f 72 20 74 68 65 20 |rmation |for the |
|00005e60| 67 72 61 70 68 20 63 61 | 6e 20 62 65 20 66 6f 75 |graph ca|n be fou|
|00005e70| 6e 64 2e 20 20 0d 54 68 | 69 73 20 63 6f 6e 73 69 |nd.  .Th|is consi|
|00005e80| 73 74 73 20 6f 66 20 74 | 77 6f 20 72 6f 77 73 20 |sts of t|wo rows |
|00005e90| 61 6e 64 20 74 68 72 65 | 65 20 63 6f 6c 75 6d 6e |and thre|e column|
|00005ea0| 73 2e 0d 0d 54 68 65 20 | 63 6f 6c 75 6d 6e 73 20 |s...The |columns |
|00005eb0| 67 69 76 65 20 74 68 65 | 20 6d 69 6e 69 6d 75 6d |give the| minimum|
|00005ec0| 20 61 6e 64 20 6d 61 78 | 69 6d 75 6d 20 66 6f 72 | and max|imum for|
|00005ed0| 20 74 68 65 20 78 2d 2c | 20 20 79 2d 20 61 6e 64 | the x-,|  y- and|
|00005ee0| 20 7a 2d 61 78 65 73 20 | 72 65 73 70 65 63 74 69 | z-axes |respecti|
|00005ef0| 76 65 6c 79 2e 0d 54 68 | 65 20 66 69 72 73 74 20 |vely..Th|e first |
|00005f00| 72 6f 77 20 63 6f 6e 74 | 61 69 6e 73 20 74 68 65 |row cont|ains the|
|00005f10| 20 6d 69 6e 69 6d 75 6d | 2c 20 74 68 65 20 73 65 | minimum|, the se|
|00005f20| 63 6f 6e 64 20 74 68 65 | 20 6d 61 78 69 6d 75 6d |cond the| maximum|
|00005f30| 2e 0d 0d 0d 00 00 00 ca | 54 68 65 20 7a 65 72 6f |........|The zero|
|00005f40| 20 74 68 72 65 73 68 68 | 6f 6c 64 20 64 65 74 65 | threshh|old dete|
|00005f50| 72 6d 69 6e 65 73 20 69 | 66 20 74 68 65 20 76 61 |rmines i|f the va|
|00005f60| 6c 75 65 20 5a 45 52 4f | 20 69 73 20 69 6e 63 6c |lue ZERO| is incl|
|00005f70| 75 64 65 64 20 69 6e 20 | 74 68 65 20 79 2d 61 78 |uded in |the y-ax|
|00005f80| 69 73 20 76 61 6c 75 65 | 73 2e 0d 0d 49 66 20 61 |is value|s...If a|
|00005f90| 20 68 69 67 68 65 72 20 | 76 61 6c 75 65 20 69 73 | higher |value is|
|00005fa0| 20 63 68 6f 73 65 6e 20 | 66 6f 72 20 74 68 65 20 | chosen |for the |
|00005fb0| 7a 65 72 6f 20 74 68 72 | 65 73 68 68 6f 6c 64 2c |zero thr|eshhold,|
|00005fc0| 20 69 74 20 69 73 20 6d | 6f 72 65 20 6c 69 6b 65 | it is m|ore like|
|00005fd0| 6c 79 20 74 68 61 74 20 | 74 68 65 20 7a 65 72 6f |ly that |the zero|
|00005fe0| 20 69 73 20 69 6e 63 6c | 75 64 65 64 0d 69 6e 20 | is incl|uded.in |
|00005ff0| 74 68 65 20 79 2d 61 78 | 69 73 20 76 61 6c 75 65 |the y-ax|is value|
|00006000| 73 2e 00 00 00 00 00 00 | 00 c5 45 73 74 61 62 6c |s.......|..Establ|
|00006010| 69 73 68 65 73 20 61 20 | 70 72 65 66 69 78 2e 0d |ishes a |prefix..|
|00006020| 41 20 70 72 65 66 69 78 | 20 69 73 20 61 20 74 65 |A prefix| is a te|
|00006030| 78 74 2c 20 74 68 61 74 | 20 69 73 20 67 69 76 65 |xt, that| is give|
|00006040| 6e 20 62 65 66 6f 72 65 | 20 74 68 65 20 63 6f 6e |n before| the con|
|00006050| 74 65 6e 74 20 6f 66 20 | 61 20 63 65 6c 6c 2e 0d |tent of |a cell..|
|00006060| 0d 41 20 63 68 61 6e 67 | 65 20 61 66 66 65 63 74 |.A chang|e affect|
|00006070| 73 20 61 6c 6c 20 65 71 | 75 61 6c 20 70 72 65 66 |s all eq|ual pref|
|00006080| 69 78 65 73 2e 0d 57 68 | 65 6e 20 5c 35 20 69 73 |ixes..Wh|en \5 is|
|00006090| 20 67 69 76 65 6e 2c 20 | 74 68 65 20 66 69 76 65 | given, |the five|
|000060a0| 20 6c 65 61 64 69 6e 67 | 20 63 68 61 72 61 63 74 | leading| charact|
|000060b0| 65 72 73 20 6f 66 20 74 | 68 65 20 63 65 6c 6c 20 |ers of t|he cell |
|000060c0| 61 72 65 20 65 6c 69 6d | 69 6e 61 74 65 64 0d 00 |are elim|inated..|
|000060d0| 00 00 c1 45 73 74 61 62 | 6c 69 73 68 65 73 20 61 |...Estab|lishes a|
|000060e0| 20 73 75 66 66 69 78 2e | 0d 41 20 73 75 66 66 69 | suffix.|.A suffi|
|000060f0| 78 20 69 73 20 61 20 74 | 65 78 74 2c 20 74 68 61 |x is a t|ext, tha|
|00006100| 74 20 69 73 20 67 69 76 | 65 6e 20 61 66 74 65 72 |t is giv|en after|
|00006110| 20 74 68 65 20 63 6f 6e | 74 65 6e 74 20 6f 66 20 | the con|tent of |
|00006120| 61 20 63 65 6c 6c 2e 0d | 0d 41 20 63 68 61 6e 67 |a cell..|.A chang|
|00006130| 65 20 61 66 66 65 63 74 | 73 20 61 6c 6c 20 65 71 |e affect|s all eq|
|00006140| 75 61 6c 20 70 72 65 66 | 69 78 65 73 2e 0d 57 68 |ual pref|ixes..Wh|
|00006150| 65 6e 20 5c 35 20 69 73 | 20 67 69 76 65 6e 2c 20 |en \5 is| given, |
|00006160| 74 68 65 20 6c 61 73 74 | 20 66 69 76 65 20 20 63 |the last| five  c|
|00006170| 68 61 72 61 63 74 65 72 | 73 20 6f 66 20 74 68 65 |haracter|s of the|
|00006180| 20 63 65 6c 6c 20 61 72 | 65 20 65 6c 69 6d 69 6e | cell ar|e elimin|
|00006190| 61 74 65 64 00 00 01 16 | 49 66 20 74 68 69 73 20 |ated....|If this |
|000061a0| 6f 70 74 69 6f 6e 20 69 | 73 20 73 65 6c 65 63 74 |option i|s select|
|000061b0| 65 64 2c 20 61 20 6e 65 | 77 20 63 61 6c 63 75 6c |ed, a ne|w calcul|
|000061c0| 61 74 69 6f 6e 20 77 69 | 6c 6c 20 66 6f 6c 6c 6f |ation wi|ll follo|
|000061d0| 77 2e 0d 0d 53 74 6f 72 | 65 20 41 6c 6c 3a 0d 49 |w...Stor|e All:.I|
|000061e0| 66 20 74 68 65 20 63 61 | 6c 63 75 6c 61 74 69 6f |f the ca|lculatio|
|000061f0| 6e 20 69 73 20 63 61 6e | 63 65 6c 6c 65 64 20 64 |n is can|celled d|
|00006200| 75 72 69 6e 67 20 70 68 | 61 73 65 20 6f 6e 65 2c |uring ph|ase one,|
|00006210| 20 69 74 20 6d 75 73 74 | 20 62 65 20 72 65 70 65 | it must| be repe|
|00006220| 61 74 65 64 2e 0d 49 66 | 20 74 68 65 20 63 61 6c |ated..If| the cal|
|00006230| 63 75 6c 61 74 69 6f 6e | 20 69 73 20 63 61 6e 63 |culation| is canc|
|00006240| 65 6c 6c 65 64 20 64 75 | 72 69 6e 67 20 70 68 61 |elled du|ring pha|
|00006250| 73 65 20 74 77 6f 2c 20 | 69 74 20 63 61 6e 20 62 |se two, |it can b|
|00006260| 65 20 72 65 73 75 6d 65 | 64 20 62 79 20 70 72 65 |e resume|d by pre|
|00006270| 73 73 69 6e 67 20 11 32 | 2e 0d 0d 53 74 6f 72 65 |ssing .2|...Store|
|00006280| 20 46 6c 65 78 69 62 6c | 65 3a 0d 41 6c 6c 20 73 | Flexibl|e:.All s|
|00006290| 74 6f 72 65 64 20 72 65 | 73 75 6c 74 73 20 77 69 |tored re|sults wi|
|000062a0| 6c 6c 20 62 65 20 64 65 | 6c 65 74 65 64 2e 00 00 |ll be de|leted...|
|000062b0| 00 7f 53 74 61 72 74 73 | 20 61 20 6e 65 77 20 63 |..Starts| a new c|
|000062c0| 61 6c 63 75 6c 61 74 69 | 6f 6e 2e 0d 54 68 69 73 |alculati|on..This|
|000062d0| 20 6f 70 74 69 6f 6e 20 | 69 73 20 6f 6e 6c 79 20 | option |is only |
|000062e0| 61 63 63 65 73 73 69 62 | 6c 65 2c 20 69 6e 20 74 |accessib|le, in t|
|000062f0| 68 65 20 65 76 65 6e 74 | 20 74 68 61 74 20 74 68 |he event| that th|
|00006300| 65 20 53 74 6f 72 65 20 | 41 6c 6c 20 6f 72 20 53 |e Store |All or S|
|00006310| 74 6f 72 65 20 46 6c 65 | 78 69 62 6c 65 0d 6f 70 |tore Fle|xible.op|
|00006320| 74 69 6f 6e 20 69 73 20 | 73 65 6c 65 63 74 65 64 |tion is |selected|
|00006330| 2e 00 00 00 f2 41 20 6e | 65 77 20 63 61 6c 63 75 |.....A n|ew calcu|
|00006340| 6c 61 74 69 6f 6e 20 66 | 6f 6c 6c 6f 77 73 2e 0d |lation f|ollows..|
|00006350| 0d 53 74 6f 72 65 20 41 | 6c 6c 3a 0d 49 66 20 74 |.Store A|ll:.If t|
|00006360| 68 65 20 63 61 6c 63 75 | 6c 61 74 69 6f 6e 20 69 |he calcu|lation i|
|00006370| 73 20 63 61 6e 63 65 6c | 6c 65 64 20 64 75 72 69 |s cancel|led duri|
|00006380| 6e 67 20 70 68 61 73 65 | 20 6f 6e 65 2c 20 69 74 |ng phase| one, it|
|00006390| 20 6d 75 73 74 20 62 65 | 20 72 65 70 65 61 74 65 | must be| repeate|
|000063a0| 64 2e 0d 49 66 20 74 68 | 65 20 63 61 6c 63 75 6c |d..If th|e calcul|
|000063b0| 61 74 69 6f 6e 20 69 73 | 20 63 61 6e 63 65 6c 6c |ation is| cancell|
|000063c0| 65 64 20 64 75 72 69 6e | 67 20 70 68 61 73 65 20 |ed durin|g phase |
|000063d0| 74 77 6f 2c 20 69 74 20 | 63 61 6e 20 62 65 20 72 |two, it |can be r|
|000063e0| 65 73 75 6d 65 64 20 62 | 79 20 70 72 65 73 73 69 |esumed b|y pressi|
|000063f0| 6e 67 20 11 32 2e 0d 0d | 53 74 6f 72 65 20 46 6c |ng .2...|Store Fl|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.